Use the Text Export function to export data to a text file in a variety of formats, including text dump, comma delimited, tab delimited, space delimited, other delimiter and spreadsheet. You can also write field names to the text file, in which case they may be enclosed using a character you specify.
Select File | Export | Text to open the Export Text form:
File
Specify the name and type of the source file and optionally apply a filter.
Output
Text file path
Type the full path name of the output file. A new file will be created in that location.
Replace non-numeric and blanks
Type the replacement for non-numeric or blank characters found in numeric fields. If these options are left blank, non-numeric or blank values will be written to the output file.
Left justify
If you want to left-justify numeric fields select this check box (Note that this option only applies to a file format of 'Other'; the default is right-justified).
Options
Text file format
Select a TEXT DUMP, SPREADSHEET or DELIMITED file format.
Files containing binary fields cannot be output as a TEXT DUMP. Choose a delimited format or use File | Utilities | Binary to ASCII to convert the Input file.
Delimiter
If you selected DELIMITED as the file format, enter a Delimiter character. Delimiters are ASCII characters used to separate one data field from the next.
Enclose character values and numeric values
Optionally, specify a character that will be used to enclose character and numeric values when they are written to the output file.
Write field names to first record
If you want to include field names on the first line of the output file, select this option.
Enclose field names
If the Write field names option is selected, optionally specify a character that will be used to enclose each field name on the first line.
See Also