Specifying an analysis method for line break codes and enclosure characters in CSV files
|
For CSV files, you can now specify the following settings in the system environment settings file:
-
In previous versions, if a line break was contained within a field enclosed by CSV enclosure characters, it was output as a record delimiter. From DataMagic Ver.3 onward, you can now also specify to handle line breaks inside CSV fields as data. Even when there are line breaks inside CSV fields, if the line breaks are to be regarded as data, specify this as follows.
-
Select the Treat a line break as part of a field check box in the Data processing information settings tab of the System Environment Settings screen.
-
To make this setting, specify "1" in the treat a line break as part of a field (ed_csv_linebreak) field of the system environment settings file (huledenv.conf).
-
In previous versions, if a field contained the same value as an enclosure character, the value was output as data. From DataMagic Ver.3 onward, a new setting can now be specified to escape characters if there are two enclosed fields in a row.
-
Select the Escape enclosure characters inside an enclosed text check box in the Data processing information settings tab of the System Environment Settings screen.
-
To make this setting, specify "1" in the escape enclosure characters inside an enclosed text (ed_csv_enclosefields) field of the system environment settings file (huledenv.conf).