Data Transformation Engine Type Tree Maker Reference Guide

Chapter 4 - Commands and Command Elements Command Element Descriptions
Sub-string Values Description
not used, default is S.
"[" + value + min-
digits(1) + "##" +max-
digits(1) + "]"
Specifies the value of the decimal separator to be
optional if there is no fractional portion of the
number. It also specifies the range of fraction
digits. If min-digits is not used, default is zero. If
max-digits is not used, default is S.
Trailing-Sign
The following table describes the optional Trailing-Sign format string.
Sub-string Values Description
"T" + Positive + Negative +
Zero(1)
A trailing sign is required for positive numbers
and negative numbers.
"T"+ "[" + Positive + "]" +
Negative + Zero(1)
A trailing sign is optional for positive numbers
and required for negative numbers.
"T" + Positive + "[" +
Negative + "]" + Zero(1)
A trailing sign is required for positive numbers
and optional for negative numbers.
"T"+ Positive + Zero(1) A trailing sign is required for positive numbers
and there is no trailing sign for negative
numbers.
"T" + Negative + Zero(1) A trailing sign is required for negative numbers
and there is no trailing sign for positive
numbers.
Sign Sub-string formats
The following table describes the sub-strings:
Sub-string name Sub-string Values Meaning
Positive "+" + value(1)
Negative "–" + value(1)
Value A text-string enclosed in
single-quotes. Value has a
release character of "/" if
The sign value of the previous
sign-indicator. If Value is not
used, the default is "+" for