6-24
• Anything in a CSV file between a pair of quotation marks (" "), between quotation marks
(") and a line feed, or between quotation marks (") and the end of a file is treated as a text
string. Any delimiter symbol within a text string range is ignored.
CSVInfo
Function: Gets the row count and column count of the CSV file specified by the path and file
name and outputs the result in list format.
Syntax: CSVInfo "<path>\\<filename>"
Example: CSVInfo "SMEM:\\Data0827.csv"→List 1
The above gets the row count and column count of the file named "Data0827.csv",
which is located in the storage memory root directory, and outputs the result to List
1 in the format {row count, column count}.
CSVInfo "SD:\\FOLDER1\\Data0827.csv"→List 1
The above gets the row count and column count of the file named "Data0827.csv",
which is located in FOLDER1 of the SD card, and outputs the result to List 1 in the
format {row count, column count}.
Description:
• If the CSV file contains rows of different lengths (different number of columns), the number of
columns value produced by this command will be for the longest line.
• This command cannot be used to access a CSV file that is currently open with the OpenCSV
command.
OpenCSV
Function: Opens the CSV file specified by the path and file name (including extension).
Syntax: OpenCSV "<path>\\<filename>"
Example: OpenCSV "SMEM:\\Data0827.csv"
OpenCSV "SD:\\FOLDER1\\Data0827.csv"
Description:
• A CSV file must be opened with this command in order to load data from the file.
• A file with a file name extension other than .csv (such as .txt) can be specified with this
command as long as it is a text file that includes delimiter symbols and line feed codes.
• Opening multiple instances of the same file and opening multiple CSV files at the same time
are not supported. To re-open the currently opened CSV file, first be sure to execute the
CloseCSV command then execute the OpenCSV command.
CloseCSV
Function: Closes the currently open CSV file.
Syntax: CloseCSV
Description: This command is used in combination with the OpenCSV command. The
currently open CSV file is forced to close automatically when a program ends, even if
CloseCSV is not executed.
