Output Mask
Define the column's print and display format mask. The following mask characters can be used:
Character |
Description |
B |
Inserts a space character. |
CR |
Inserts the "CR" string if the number is negative, or two spaces if the number is positive. |
DR |
Inserts the "CR" string if the number is negative, or the "DR" string if the number is positive. |
0 |
Replaces characters with digits (i.e., 0..9). |
# |
Suppresses leading zeros. Replaced by a fill character for leading zeros to the left of the decimal point. Replaced by a space character for trailing zeros to the right of the decimal point. Any other time it is replaced by a digit. |
* |
Inserts an asterisk character. |
, |
Inserts a fill character to the left of the decimal point if no digits have been placed. Otherwise, it inserts a comma into the result. |
. |
Inserts a decimal point if any characters have been placed, otherwise, it inserts a fill character. After the decimal point, it replaces the fill character with a space character. |
( |
Inserts a left parentheses if the number is negative, or the fill character if the number is positive. |
) |
Inserts a right parentheses if the number is negative, or a fill character if the number is positive. |
- |
Displays a minus sign if the number is negative, or a space character if the number is positive. |
+ |
Displays a plus sign if the number is positive, or a minus sign if the number is negative. |
$ |
Displays a dollar sign ($). |