Print — Mask

July 23, 2012

by roger

Decimal masks

In addition to the “#” placeholder, the “0” (zero) is used with decimal numeric values. The zero is valid only in the decimal portion of the mask (to the right of the decimal point).

field1 mask “##,###.##” — prints the value rounded to two decimal places.
- 1234.560 prints 1,234.56
- 1234.565 prints 1,234.57
field1 mask “#####.##” — prints as above without any comma separators.
- 1234.56499 prints 1234.54
field1 mask “##,###.00” — For each zero in the mask, if the field value resolves to zero in the rightmost position as a zero in that position, the zero value does not print. This is the method to trim a decimal value. In this case both the decimal positions are set to trim.
- 1234.50 prints 1,234.5
- 1234.56 prints 1,234.56
- 1234.06 prints 1,234.06 (the zero fails on the rightmost digit).
- 1234.00 prints 1234 (if the value resolves to zero decimal places, it prints as an integer).
field1 mask “##,###.#00” — all of the values will print at least one and at most three decimal places.
- 1234.567 prints 1,234.567
- 1234.001 prints 1,234.001 (the mask zero fails on the rightmost digit).
- 1234.510 prints 1,234.51
- 1234.500 prints 1,234.5
- 1234.000 prints 1,234.0 (the first decimal place on the mask is a “#”, not a “0”).
field1 mask “$##,###.##” — value rounded to two decimal places with a dollar sign.
- 12345.67 prints $12,345.67
- -12345.67 prints $-12,345.67
field1 mask “$(##,###.##)” — negative values replace the minus sign with parentheses. The right parenthesis is not required.
- 12345.67 prints $12,345.67
- -12345.67 prints $(12,345.67)
field1 mask “$ ##,##.##” — the dollar sign can be padded with additional spaces
- 12345.67 prints $ 12,345.67
field1 mask “$ (##,###.##”
- -12345.67 prints $ (12,345.67)