4-32 A-61635 December 2010
Transform Expressions 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
Transform text formats [start]
[start, end]
[index, ‘delimiter’]
[start; len]
These formats are used to extract a sub-string from the original index value.
[start] — used to extract a sub-string starting at the position start to the end of
the original value.
• If start is a positive number, the start position will be counted from the
beginning of the original value.
• If start is a negative number, the start position will be counted from the end
of the original value.
• If start is 0 or *, the start position will be the beginning of the original value.
To Next Page
Loading...