When exporting/importing from a Character Separated Values (CSV) file, you can specify several encoding/decoding settings:
Setting
Description
Field Delimiter
The character to use as the column delimiter. Default is semicolon (;).
Use Text Qualifier
Sets whether text qualifiers will be used while writing/parsing data or not. When exporting data, there are three choices: Do not use, Use when necessary (i.e. when text itself contains field delimiters or other reserved characters) and Use always.
Text Qualifier
The character to use as a text qualifier in the data. Default is double quote (").
Escape Mode
There are two modes that may be used to escape qualifier characters in the data:
Use a backslash character before the text qualifier to represent an occurrence of the text qualifier;
Double up the text qualifier to represent an occurrence of the text qualifier.
Comment Character
The character to use as a comment signal.
Header Record
Defines content of the first record of a CSV file. Possible choices are:
None. The CSV file has no header record, first record contains raw data. In the case of import, it means that data from the first line of the CSV file will be imported in the first record of Data Table and so on.
Field Names. First record of the CSV file contains names of Data Table fields. In the case of import, it helps to match column of the CSV file and field of the Data Table.
Field Descriptions. First record of the CSV file contains descriptions of Data Table fields. In the case of import, it helps to match column of the CSV file and field of the Data Table.
Ignore As Non-Valuable Data. This option is available during import operation only. It causes import operation to skip first record of the CSV file. In the case of import, the first line of the CSV file will be skipped and the data from the second line of the CSV file will be imported in the first record of Data Table and so on.
Export Value Descriptions Instead Of Values
Defines what's written to a CSV file if a field has Selection Values:
