A-61635 December 2010 4-39
Fixed string formats text”
text is any text string. Because the start and end of the text string is defined by
the character “ (double quote), the double quote character is not allowed in the
text string. A text string format is normally used in combination with other input
formats.
Examples
"ID-"[*]"-XX"
Description — output fixed text string of "ID".
Examples
"20051026" ==> "ID-20051026-XX"
Combining Transform
formats
A Transform Expression can consist of multiple formats that are used in
combination. To use multiple formats to define a Transform Expression simply
connect the format expressions together with or without a blank space.
Examples
"Revenue"c<20, 2>
Description — combination with formats "Revenue" and c<20, 2>.
Examples
"123456" ==> "Revenue 123,456.00"
yyyy"/"MM"/"dd"-"HH":"mm":"ss
Description — combined with formats: yyyy, "/", MM, "/", dd, "-", HH, ":", mm, ":"
and ss.
Examples
"20051026080405PM" ==> "2005/10/26-20:04:05"
Input Format: T<yyyyMMddhhmmssTT>
Output formats An Output Format is a text expression to format the data of a particular index
field into an output value. Transform Expressions are used to define the output
format for an index field.
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 syntax can be one or a combination of the following formats:
• Text formats — see Transform Expression, Text formats
• Number formats — see Transform Expression, Number formats
• Time formats — see Transform Expression, Time formats
• Fixed string formats — see Transform Expression, Fixed string formats
• Combination formats — see Transform Expression, Combining Transform
formats
To Next Page
Loading...