Data Export Options Dialog

The Data Export Options dialog may appear when exporting tabular data from delimited text files (i.e. .DAT, .TXT). These file formats are assumed to have one record per line in which each record contains a fixed number of numeric data fields.

 

Specify the delimiter and text qualifier in

the Data Export Options dialog.

 

Delimiter

Choose Comma, Tab, Space, or Semicolon as the character to use to delimit fields in the saved .DAT, or .TXT  file.

 

Text Qualifier

Select (none) for no qualifiers in the export file. Select Double quotes to place double quote characters “” around fields in the export file.  Select Single quotes to place single quote characters ‘’ around fields in the export file.

 

Decimal Symbol

Decimal symbol is the symbol used as the decimal point. This can be a comma or period. This option is only available with .TXT files.

 

Encoding Method

The Encoding method section allows the choice of Windows Unicode data, Encoded UTF-8 data, or Unencoded ANSI translated using data when exporting or saving an ASCII data file. Windows Unicode and Encoded UTF-8 data are often referred to as international data. It would include character sets from Russia, Israel, China, Greece, Hungary, among others. If the data does not appear correctly in the exported file, the Encoding method may be specified incorrectly.

 

ANSI encoding contains characters within the first 256 characters of a font. These are normally in English. After selecting Unencoded ANSI translated using [codepage], select the codepage from the list that will read the data correctly.

 

OK and Cancel Buttons

Click the OK button to proceed with the export process, or click the Cancel button to close the dialog without exporting the data set.

 

 

See Also

Data Import Options Dialog

ASCII TXT, DAT, and CSV Data Files