Transform Expression

A Transform Expression is a text expression to format or transform the data of a particular field into a default or output value. Transform Expressions are used to define default values and output format for an index field.

Default value specification: when a new batch or document is created, the index field will be populated with a value based on the default value specification. The default value specification is entered on the Index tab and takes the form <tagname> or <tagname:transform expression>. The transform expression is described below.

Examples:

<sys.date:ddMMyy>

<sys.stationid:[1,5]>

Output format: when a batch is output, the index data for the batch and for each document in the batch will be reformatted based on the output format. For instance, a date index with a value of MMddyy can be reformatted to: MM/dd/yyyy.

The Output format is entered on the Index tab and takes the form: transform expression.

Examples:

ddMMyy

[1, 5]

The syntax can be one or a combination of the following formats:

Text formats

Number formats

Time formats

Fixed string formats