This section explains the CSV format supported.
Example
CSV description example
"01","1001","AAA","BlockA","1,000","1,000","Comment: Memo number 4023"
"02","1001","BBB","BlockB","","1,200","Comment: Memo number 4023"
"03","1002","CCC","BlockC","800","800","Comment: Memo number 4023"
Use commas (,) to delimit the items in the columns in one record.
Records are separated by newline characters.
Items can be enclosed by double quote marks (""). If a comma or newline needs to be specified in an item, enclose the item in double quote marks.
If a double quote mark (") needs to be specified in the content of an item, enclose the item in double quote marks and then add a double quote mark before the one that is part of the item (that is, specify two consecutive double quote marks).
Example
When items 'A,AA', 'BnewlineBB', and 'C"CC' are included in a record
"A,AA","B
BB","C""CC"
When data is enclosed by double quote marks, an error will occur if a character other than a comma (,) is used between items. Delete any excess characters around delimiting commas (,).
Example
Incorrect: There are unnecessary spaces (underlined) between items (around the comma).
"AAA", "BlockA"
Correct: There are no unnecessary spaces between items.
"AAA","BlockA"
The maximum size of one record is 32 MB (megabytes).
For input events, records do not need to be separated by newlines. Multiple records cannot be handled in one input event.