Data Transformation Engine Type Tree Maker Reference Guide
Chapter 4 - Commands and Command Elements Command Element Descriptions
Leading-Sign
The following table describes the optional Leading-Sign format string.
Sub-string Values Description
"L" + Positive + Negative +
Zero(1)
A leading sign is required for positive numbers
and negative numbers.
"L"+ "[" + Positive + "]" +
Negative + Zero(1)
A leading sign is optional for positive numbers
and required for negative numbers.
"L" + Positive + "[" +
Negative + "]" + Zero(1)
A leading sign is required for positive numbers
and optional for negative numbers.
"L" + Positive + Zero(1)
A leading sign is required for positive numbers
and there is no leading sign for negative
numbers.
"L" + Negative + Zero(1)
A leading sign is required for negative numbers
and there is no leading sign for positive
numbers.
Example
{L+}
Whole#
The following table describes the required Whole# format string.
Sub-string Values Description
min-digits(1) + "#” +
value(1) + "###" + max-
digits(1)
-or-
min-digits(1) + "#" + "["
+ value(1) + "]" + "###"
+ max-digits(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.
"V" + implied-places Specifies the decimal to be implicit and implied
places specifies where the intended decimal
separator is to be placed.
value + min-digits(1) + Specifies the value of the decimal separator to be