Data Transformation Engine Functions and Expressions Reference Guide

Appendix B - Format Strings Number Format Strings
Functions and Expressions Reference Guide
247
Sub-String Name Sub-String Value
"[AM/PM]"
Zone
"+/-ZZZZ"
"ZZZ"
"[+/-ZZZZ]"
"[ZZZ]"
Separator Separator is optional. If specified, it can be up to 120 bytes,
composed of non-alphabetic characters. Symbol table values,
such as <CR>, can be used to indicate non-printable
characters.
MinuteSet Separator required if Hours is H24 or H12
SecondSet Separator required if MinuteSet is M
FractionSet Separator required if SecondSet is S
Number Format Strings
You can create custom number formats by using the format strings as described in
the following sections.
Format String
Decimal
"{" + Leading-Sign(1) + Whole# + Fraction + Trailing-Sign(1) + "}"
Integer
"{" + Leading-Sign(1) + Whole# + Trailing-Sign(1) + "}"