| Conversion Wizard - CSV Information Setup |
| Specify how Data Converter should handle CSV (Comma-Separated Values) files. |
| Item | Explanation | ||||||||||||||||||||||||||||||||||||
| 1. Quotes | Specifies the quote marks used for character strings. | ||||||||||||||||||||||||||||||||||||
| 2. Delimiter | Specifies the delimiter between CSV fields. The default is comma "," which is the standard CSV delimiter. | ||||||||||||||||||||||||||||||||||||
| 3. Output quoted data using double quotes | Specifies that quotes within character strings should be made into double quotes. For example the string: 'Label is 'ABC'.', would be output as: 'Label is "ABC".' | ||||||||||||||||||||||||||||||||||||
| 4. Output null character as double quotes | Specifies that character fields containing null should be
output as a double quote. For example, the following data: 02 ITEM1 PIC 9(3) VALUE 100. 02 ITEM2 PIC X(5) VALUE LOW VALUES. 02 ITEM3 PIC 9(3) VALUE 100. Would be output as: 100,",100, with this box checked, and 100,,100 with the box not checked. |
||||||||||||||||||||||||||||||||||||
| 5. Output item header in first record | Only valid for output files. If checked Data Converter outputs the item names in the first record of the CSV file. This makes the CSV file convenient to import into a spreadsheet. |
||||||||||||||||||||||||||||||||||||
| When you use the "Reference settings", these settings are automatically selected for the appropriate data store. The row numbers in the following table correspond to those under the heading "Item" above. | |||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||