Filter
Top Products
CHAPTER 8 Displaying and Validating Data
DataWindow Designer User’s Guide 235
String display formats
String display formats can have two sections. The first is required and contains
the format for strings; the second is optional and specifies how to represent
NULLs:
string-format;null-format
In a string format mask, each at-sign (@) represents a character in the string
and all other characters represent themselves.
Example
This format mask:
[red](@@@) @@@-@@@@
displays the string 800YESCELT in red as:
(800) YES-CELT
Date display formats
Date display formats can have two sections. The first is required and contains
the format for dates; the second is optional and specifies how to represent
NULLs:
date-format;null-format
Special characters
Table 8-4 shows characters that have special meaning in date display formats.
$#,##0;($#,##0) $5 ($5) $1
$#,##0;-$#,##0 $5 -$5 $1
$#,##0;[RED]($#,##0) $5 ($5) $1
[Currency] $5.00 ($5.00) $0.50
$#,##0.00;($#,##0.00) $5.00 ($5.00) $0.50
$#,##0.00;[RED]($#,##0.00) $5.00 ($5.00) $0.50
##0% 500% -500% 50%
##0.00% 500.00% -500.00% 50.00%
0.00E+00 5.00E+00 -5.00E+00 5.00E-01
Format 5 -5 .5