FLD_DELIMITER

Restriction: This topic applies to Windows environments only.

Specifies the delimiter used to separate fields in free-format ASCII files. The default delimiter is a comma. The syntax is:

FLD_DELIMITER = {"xx" | "<ascii>"...};  

where:

xx is a character string delimiter
ascii is an ASCII decimal code.

Delimiters can be specified as a character string or in ASCII decimal notation. If the delimiter is specified as a character string it must be enclosed in double-quotation marks ("   "). If the delimiter is specified in ASCII decimal notation, enclose each ASCII code in angled brackets. For example, to use the decimal notation for a semicolon, enter the string <59>. (The angled brackets around the ASCII code are required.)

Note:

You must determine the field delimiter prior to executing the Export function. If you specify a field delimiter that is not found in the file, the Batch Export program will abort and an error message will be displayed.

Use the Target File command from the View menu (or a text editor) to examine the file. If the field delimiter is an nonvisible ASCII character, you may have to use a hexadecimal editor to examine the contents of the file.

Take care not to choose a character found in your data as a delimiter. For example, do not use a comma as the delimiter if your data contains numeric or money fields grouped with a comma.

For example:

FLD_DELIMITER = ",";

separates the data with a comma.