Skip to content

Format Selection

Format

You can select one of the following four choices:

  1. With Comma Separated
    Each database record is stored on one separate line, while the fields are separated by a field separator, which you specify via the field separator form on this same wizard page.

  2. With Line Delimited
    Each database record is stored on multiple lines, with each field on a separate line in the output file. The number of lines in the output should be equal to the number of records multiplied by the number of fields.

  3. With Fixed Position
    This is also referred to as columnar output. Each field starts at a position that is equal to the previous field position plus its length plus one space.

  4. With XML
    Data will be exported to an XML file following the XML rules.

Field Separator

If you select the comma-separated output, you may enter the separator character(s) to be used for the field separator.

The field separator is not limited to one character; thus, if you want to specify multiple characters, you are free to do this. Use unique characters and do not use double quotes, as they will be used normally around literal texts.

The default separator according to your Windows locale will be shown in this form.