Symbols allowed in the mask
The following table lists and describes symbols that are allowed in mask.
Symbol | Meaning |
9 | A numeric position |
* | A leading numeric position in which an asterisk is placed if this position contains a 0. |
Z | A leading numeric position in which a space is placed if this position contains a 0. |
. | The decimal point. Output is aligned on this position. This symbol is replaced by the appropriate symbol for the output language. |
, | A thousand-separator. This symbol is replaced by the appropriate symbol for the output language. |
$ | A single-character currency symbol. This symbol is replaced by the appropriate symbol for the output language. |
U | A multi-character currency symbol. This symbol is replaced by the appropriate 3-character ISO 4217 code for the output language. |
+ | Editing sign control |
- | Editing sign control |
CR | Editing sign control. The CR symbol is only permitted at the end of the mask |
DB | Editing sign control. The DB symbol is only permitted at the end of the mask. |
B | A space |
/ | A slash. Note that the / must be escaped when written in a "…" expression. |
All symbols are case-insensitive.
Repeating symbols can be abbreviated by specifying a repeat-count between parentheses.
The following two patterns are equivalent:
"$9(5).9(2)CR"
"$99999.99CR"