XFA Specification
Chapter 24, Picture Clause Specification
Picture Clause Reference
929
Picture clause
S999v99
S999V99
Input value
-1.23
1.23
123
Formatted results
"-00123"
" 001.23"
" 123.00"
"
12.30"
SZZ9.99
12.3
-12.3
"- 12.30"
"123.00"
"-123.00"
"$
"$
1,234.00
"
szz9.99
123
-123
$ZZ,ZZ9.99CR
1234
-1234
1,234.00CR"
$z,zz9.99DB
1234
-1234
"$1,234.00"
"$1,234.00DB"
12.345E+3
12.345E-3
99.999E
12345
.12345
Examples of Input Parsing
Conversely, the application of picture clauses to numeric or monetary values can be used to produce
numeric data results, as in the following example:
Picture clause
99V99
Input value
1050
3125
Parsed results
10.50
31.25
12345
.12345
150
150
10.50
3125.00
1234.00
-1234.00
99.999E
12.345E3
12.345E-2
z999
150
0150
z,zz9.99
10.50
3,125.00
$z,zz9.99DB
$1,234.00
$1,234.00DB
If the distinction between various numeric picture symbols appears subtle, it's to provide the flexibility
normally required when strict parsing and formatting rules are in place. For instance, a number value of
150 should be accepted given the picture clause
z999
; the addition of a leading zero to the value does not
change the value from 150, i.e., the values 0150 and 150 are equivalent.
Similarly the picture clause
S9999
would accept the value -5000 or +5000 or 5000.