Field help (AOEFLD)

This field indicates the name of the field of the table to be imported or exported. Different syntaxes are possible to define the information to be extracted or integrated:

• The slash means that a group indicator is written upon export or searched for during import. In a template used for import, when several groups exist, this separator is mandatory for each group. The group separator is supposed to be a normal field enclosed by field separators and delimiters if the Delimited template type is used.
• The most simple syntax is FIELD(index) when a field coming from the table declared in the previous column is imported or exported. A selection window displays the possible fields.
• If a constant string of characters enclosed between double quotes is entered here, the field will be written as it is in the file to be exported and ignored in the import.
• If nothing is entered, there will be an empty field in the exported file enclosed by field delimiters if the template is of the Delimited type. In import mode, it means that the corresponding field must be ignored.
• The *N syntax, where N is a number between 1 and 99, is also possible. You can use it to assign in import or to read in export the GIMP(N) variable. GIMP is a global variable of character string type with a maximum length equal to 100. You must assign it in a specific/custom process associated with the import or export.
• The last possibility, only used in export, is to define any calculated expression preceded by =. This expression can call constants, functions, variables, operators, and fields coming from online tables. Its syntax is verified upon entry. The control of the context, such as the fact that the variables exist, cannot be verified.