Delimited Text File Export Rules in the Table Window
When you export the table to a delimited text file, Monarch Classic uses the following rules to create the export file.
Records
The active filter, if any, determines which records will be exported. Only those records that satisfy the filter are exported. This creates an export file that matches the records you see on screen in the Table window.
Fields
Hidden fields are excluded from the export file. All other fields, including calculated fields, are exported.
To export a character field or memo field, Monarch Classic first removes all trailing spaces from each field value, resulting in field values of varying lengths. For memo fields, Monarch Classic also removes all CR/LF sequences from the field. Otherwise, the CR/LFs would represent the end of a record in the delimited text file.
Character field values and memo field values are optionally enclosed in quotes to differentiate them from other field types. See the "Put 'quotes' around character field values" setting in Export Options.
Date fields are always exported in the eight character YYYYMMDD format.
Numeric fields are always exported in their most compact form, without currency symbols or thousands separators.
Field names
Monarch Classic can optionally export the field names as the first record. To export the field names, select the Include field names as the first row of output setting in the Field Names tab of Export Options.
Note: When appending data to a delimited text file, the field names are not included as the first row of data, regardless of the state of the "Include field names as first row of output" setting.
Field delimiters
Monarch Classic separates field values in a delimited text file with a special delimiter character, usually a comma. You can specify another delimiter character. To do so, select the radio button of the delimiter you'd like to use from Delimiter setting. This can be found in the Text Files tab of Export Options. You can choose from a comma, a semicolon, a tab, or any delimiter you wish to apply (other).
© 2024 Altair Engineering Inc. All Rights Reserved.