Data Transformation Engine Type Designer Reference Guide

Chapter 5 - Item Properties Number Item Subclass Properties
Property Description
#.####
The thousands separator is required on input in the proper
location. The separator is built on output.
1000’s Syntax > Value
Define the thousands separator as either literal or variable. Select one of the
following from the drop-down list in the Value column:
Property Description
Literal The thousands syntax is a constant literal specified in the
1000’s Syntax > Value column.
Variable The thousands syntax allows for variable values. Use the
1000’s Syntax > Default, Item, and Find properties to
define the variable fraction separator.
1000’s Syntax (Literal) > Value
For the literal thousands separator, define the literal separator by typing the literal
separator character in the Value column or by clicking
(browse) to display the
Symbols dialog box in which you can insert any non-printable value.
A separator can be from one to 120 bytes in length. A separator cannot start or
end with a digit and cannot be the
? character. The? character is a reserved
character that can be used as a wildcard to represent any single valid character.
1000’s Syntax (Variable) > Default
Use the 1000’s Syntax > Default property to define the default variable
separator value for the thousands place. The default literal separator value for
thousands syntax is a comma.
Enter the default variable separator character or click the
(browse) to display
the Symbols dialog box in which you can insert any non-printable value.
1000’s Syntax (Variable) > Item
For integer numbers with a variable thousands separator, the Separator property
is Yes, and the 1000’s Syntax is Variable, you can specify an item type for the
variable thousands separator.
You can select the desired syntax item from the drop-down list. Or, with the focus
on the Item property (in the Value column), press Alt and drag the default
separator type item from the type tree window into the Value column.