View Single Post
  #4 (permalink)  
Old 09-09-2009, 11:28 PM
michaelm michaelm is offline
Junior Member
 
Join Date: Aug 2009
Posts: 30
Default

In my last post I forgot to put the "," between the words false and true. I do need both because I have no header and I want the column names to be "Column1, column2, etc.

From Main Help:
Quote:
Loads data to the Table from a CSV file.
Syntax: LoadCSV (File Name, Separator Character, Header Exist, Create Columns)
Separator Character - The character that is used to separate between the values. Usually , (comma)
Header Exist - A boolean that tells if the first row in the file is the columns names (header values) or the file contains only the data.
Create Columns - If set to True, new columns will be created (type - cString). If false the current columns will remain and the data will be added. In the second case the column number and type must match the data.


If HeaderExist is True and CreateColumns is True: New columns will be created named as the values of the first row in file.
If HeaderExist is True and CreateColumns is False: The data will be added to the current columns ignoring the first row in file.
If HeaderExist is False and CreateColumns is True: New columns will be created named Column1, Column2...
If HeaderExist is False and CreateColumns is False: The data will be added to the current columns including the first row in file.
Example:
Table1.LoadCSV ("data.csv", ",", True, True)
I'm new to this so maybe I'm mistaken.
Reply With Quote