Export fields

Command group Flag affected Reversible Execute on client Platform(s)
Importing and Exporting YES NO NO All

Syntax

Export fields index-name ([Indirect][,Use search][,Disable messages]) {list-of-field-names (Name1,Name2,...)}

Options

Indirect If specified, the command uses the contents of the first field as the list of fields
Use search If specified, the command uses the current search to select data
Disable messages If specified, the command does not open messages requiring a user response and instead it writes a limited amount of information to the trace log

Description

Export fields exports the data for the list of fields to the current export file. It provides runtime access to the functionality of the export data dialog in the IDE. The command sets the main file for the export to the file corresponding to the first field in the list. The index-name is the optional name of the indexed field which determines the order of the exported data.

Example

; export to a file called myExport.txt in the root of your omnis tree
Calculate lExportPath as con(sys(115),'myExport.txt')
Set print or export file name {[lExportPath]}
Prepare for export to file {Delimited (commas)}
Export fields fCustomers.CustomerID {fCustomers.Surname,fCustomers.FirstName}
End export
Close print or export file