Use the Advanced tab to perform an import/export under the following conditions:
If you are importing/exporting delimited fields, see Delimited Data. If you are importing or exporting fixed-width fields, see Fixed-Width Data.
You can specify the following values:
Indicates that the next character is the first character in the field
Indicates that the preceding character is the last character in the field
Indicates whether the name of the column is included in the data file
For example, the following settings:
Field Separator: Semicolon
Field Start: `
Field End: '
Record Separator: Empty line
Column Definition: true
Delimiter at End: false
might export the following data into the data file:
`TOY' `PRICE' `QUANTITY'
`barbie';`9.50';`0'
`beanie baby elephant';`6.50';`0'
To create or read from a data file that uses fixed-width columns instead of field separators:
The grid displays the column names in the table or view and (for export) default column widths.
Version 5.2