Table Export window: Fields

 


Product

The product (dictionary) containing the table you want to export the contents of.

Table

The technical name of the table from which data is being exported.

Key

The key by which the exported data will be sorted.

Export File name

The name of the file to which table data is being exported.

Include Header Information

Mark this option to include column header information in the export file.

Column Headings

Specifies what to use for column headings. You can use the field’s technical name, physical name or choose not to have a column heading.

Export Type

Specifies whether the fields in each record are delimited (separated by a specified character), or a fixed width. If you choose fixed width, the width can be specified for each field.

Delimiter

Specifies the character to use to separate the fields in each record of the table. You can use a tab character, a comma, or specify a custom delimiter.

Text Identifier

Specifies that characters that will be used to enclose text and string items in the export file. You can choose quotation marks (""), single quotes ('') or none.

End of Record String

Specifies the string to include at the end of each record written to the export file. Some applications require a special sequence of characters to indicate the end of each record. Use this field to automatically insert such characters.

Scrolling window

The scrolling window lists all of the fields in the selected table. To include the field in the export file, mark the check box in the Export column. You can use the button drop list at the top of the Export column to easily mark or unmark all fields listed.

The Column Name, Type and Storage indicate the field’s technical name, storage type and storage size.

The Width specifies how many characters will be used for the field if it is exported as a fixed-width. The contents of the field will be truncated if it is wider than the specified column width.

The Justify option specifies how the contents of the field will be aligned if it is exported as fixed-width.


Documentation Feedback