22.11.7.4 Read CSV File

Reads data in cell units from a CSV file (constructed from a cell image delimited with ","), and writes it to word addresses.

_CF_read_csv/_SD_read_csv/_USB_read_csv (folder names, file names, save in addresses, start line, the number of lines read)

(When reading two lines of data, starting from the first line of the [ \CSV\SAMPLE.CSV] file in the CF memory card using the "_CF_read_csv ( )" function)

Reads two lines of data, starting from the first line of the CSV file. When the first character is a numerical value ("0" to "9", "-", or "+"), the data is stored as a numerical value. When the first character is ["], the data is treated as a character and "00h" is stored at the end of the text string. For example, when storing "DAT01-01" the data size is 8 characters, which is an even number, and a total of five words are used: Four words are used for storing the text string, and one word is used for storing "00h" at the end.

For example, when storing "DAT01-2" the data size is 7 characters, which is an odd number, and a total of 4 words are used to store the text, with "00h" stored at the end.

When the first character in the cell is a numerical value ("0" to "9", "-", "+"), it converts the value to numerical data and then writes the data to the internal device. The allowed range is from -32768 to 32767.
When the first character in the cell is ["], it writes the range with ["] to the LS device as text string data. When the size of the text string data is an odd number of bytes, "0x00" is appended to the end. When the size of the text data is an even number of bytes, "0x0000" is written to the address following the last address.
When a CSV file has two or more lines of data, the data can be read from a specified line to any line.
The amount of data that can be read from a CSV file is up to 200 single-byte characters per cell and up to 640 words per row.
When an error occurs, the error status is written in LS9137 (LS9143 for USB storage).

Editor Function Name	LS Area	Error Status	Cause
_CF_read_csv( ) / _SD_read_csv( ) / _USB_read_csv( )	LS9137/ LS9143	0000h	Completed Successfully
		0001h	Parameter error
		0002h	External Storage Error No external storage/file open error/file read error
		0003h	Write/Read error

When writing CSV file text data to the LS device, the data storage order depends on the data storage mode. For information about data storage order, please refer to the following.
22.10.7 Data Storage Mode
When "*" is specified for the folder name, the full path can be designated for the file name.
Only the 8.3 format (a maximum of 12 characters, with 8 characters for the file name, the period, and 3 characters for the extension) can be used for the file name. You cannot use file names longer than 12 characters.
To set the root folder, specify "" (empty string) as the folder name.
Maximum length of parameter 1 folder name is 32 single-byte characters.
The folder name can be appended to the parameter 2 file name. Maximum length of parameter 2 folder name + file name is 32 single-byte characters.
For example, \DATA\01\DATA.bin
An Internal Device can be specified for the second parameter (File name). Specifying Internal Device allows indirect addressing of a file name. Also, when using internal devices the maximum folder name + file name length is 14 single-byte characters.
When you specify an internal device for the file name, the file name storage order is defined by the Text Data Mode.
7.9.1 System Settings [Device/PLC] Settings Guide
The range of internal devices where you can store data loaded from CSV files is only the User Area (LS20 to LS2031 and LS2096 to LS8191).
The processing time required for importing data is proportional to the data volume of the CSV file to be read out. Parts are not refreshed until processing is complete. (If each line in the CSV file has 40 characters, and with 100 lines, it takes about 10 seconds to load the file from its beginning to the one hundredth line.)
Unlike the "_CF_read()/_SD_read( )/_USB_read()" function, the status is not saved to [s:CF_ERR_STAT]/[s:SD_ERR_STAT]/[s:USB_ERR_STAT] immediately after the function is executed. (In some cases, undefined values may be stored.)

Be sure to insert ["] at the beginning and end of text strings that start with a numeral.
For example,

[ 123, 2-D4EA ]	[ 123, "2-D4EA" ]
X	O