Data Export Options
When a file is saved in the .DAT format, the GSI Data Export Options dialog is displayed with the following options:
Choose the Delimiter and
Text Qualifier Data
Export Options dialog.
Delimiter
Delimiters are the characters used between cells in a single row (fields in a record), Select Comma, Tab, Space, or Semicolon from the Delimiter list.
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.
Text Qualifier
Select " (Double quote), ' (Single quote), or (none) from the Text qualifier drop-down list. Left-click the down arrow to display the drop-down list. The selected text qualifier will determine how non-numeric or mixed alphanumeric cell entries are identified in the .DAT file. For example, if " (Double quote) is selected, all non-numeric or mixed alphanumeric cell entries are surrounded by double quotes in the file.
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.
See Also
ASCII DAT, TXT, and CSV Data Files