Table 60. Sample Edit Masks and Resulting Fields
Mask | Value | Display |
|---|
999.99 | 34.568 | 34.57 |
9,999,999V9999 | 123,456.7890 | 123,4567890 |
8,888,888.888 | 123,456.789 | 123,456.789 |
9,999 | 1234 | 1,234 |
9,999 | 123 | 123 |
09999 | 1234 | 01234 |
9999 | -123 | -123 |
9999 | -1234 | **** |
9999 | 12345 | **** |
9999mi | -123 | 123- |
9999pr | -123 | < 123> |
999999ps | -123 | ( 123) |
999999pf | -123 | (123) |
9999na | (null) | n/a |
9999nu | (null) | (blank) |
$$9,999.99c | 1234.56 | $1.234,56 |
$$9,999.99 | 1234.56 | $1,234.56 |
$$9,999.99 | 12.34 | $ 12.34 |
$$$,$$9.99 | 12.34 | $12.34 |
9.999e | 123456 | 1.235e+05 |
B9,999 | 0 | (blank) |
B9,999 | 12345 | 12,345 |
(xxx)bxxx-xxxx | 2169910551 | (216) 991-0551 |
xxx-xx-xxxx | 123456789 | 123-45-6789 |
~~xx~xx | ABCDEFGHIJ | CDFG |
r10 | ABCDEFG | GFEDCBA |