Page History
...
This activity provides a PARSEOPTION parameter to permit you to control the way that a CSV file is parsed to best suit your case. More detailed information on the parsing options is given below under the heading 30. FOR_EACH_CSVROW#CSV CSV Parsing Options.
INPUT Parameters:
...
More detailed information on the parsing options is given below under the heading 30. FOR_EACH_CSVROW#CSV CSV Parsing Options.
Note that if the SEPARATOR parameter specifies a separator other than comma or *TAB, then the value of the PARSEOPTION parameter will be disregarded. The *EXTENDED parsing option is always used in this case.
...
Frequently the first row of CSV files contain identifiers or column headings, with the actual data not starting until row 2. In this case, *YES for this parameter to have the activity automatically skip the first row. If not specified, a default of *NO is assumed.
OUTPUT Parameters:
CSVROW
Upon each iteration, this output parameter will contain the row number for the current CSV row read.
...
The PARSEOPTION parameter permits you to specify one of the values *SIMPLE, *STANDARD or *EXTENDED. These are further described below.NOTE
| Note |
|---|
| Note: |
...
| If the SEPARATOR parameter specifies a separator other than comma or *TAB, then the value of the PARSEOPTION parameter will be disregarded. The *EXTENDED parsing option is always used in this case. |
Parsing option: *SIMPLE
This parsing option offers the best performance. However:
...