Beside digits, Numeric fields can contain separators and dollar signs, among other characteristics. Just as it happens with dates, when you read or create Numeric fields, it's almost mandatory that you specify a format to tell PDI how to interpret the incoming number. The following are the most used symbols for numbers:
|
Symbol |
Meaning |
|
# |
Digit. Leading zeros are not shown. |
|
0 |
Digit. If the digit is not present, zero is displayed in its place. |
|
. |
Decimal separator. |
|
- |
Minus sign. |
|
% |
Field has to be multiplied by 100 and shown as a percentage. |
In order to specify the format of your numbers, you have to combine them. As an example, in the sales file, the SALES field is one of the several ...
