Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Number Format Strings
Functions and Expressions Reference Guide
249
Sub-String Format Strings
Sub-String
Name Sub-String Value Meaning
Positive
"+" + Value(1)
Negative
"-" + Value(1)
Value A text-string enclosed in single-
quotes '. Value has a release
character of / if the text contains
any single quote ' or forward slash
/ characters.
The sign value of the
previous sign-indicator. If
Value is not used, the
default is + for positive
numbers and - for negative
numbers.
Zero
"Z" + Value
"[" + "Z" + Value + "]"
Specifies the required
leading sign value if the
number is zero. If Zero is
not used, there is no sign
associated with a zero.
Specifies the optional
leading sign value if the
number is zero. If Zero is
not used, there is no sign
associated with a zero.
Whole Number and Fraction Format Strings
Sub-String
Name Sub-String Value Meaning
Whole# MinDigits(1) + "#" + Value(1) +
"###" + MaxDigits(1)
or –
MinDigits(1) + "#" + "[" + Value(1)
+ "]" + "###" + MaxDigits(1)
Specifies the thousands
separator and the range of
whole number digits. If min-
digits is not used, the default is
zero. If max-digits is not used,
the default is "S". If a
ThousandsItem is specified, a
Value must be present as the
default for the syntax item.