Define formats
- Last Updated: May 24, 2024
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
The list of default formats for different data types introduced you to some of the format characters supported by ABL. The following table provides a quick summary of the format symbols you are most likely to use.
| This format character . . . | Represents . . . |
|---|---|
X |
Any single character. |
N |
A digit or a letter. A blank is not allowed. |
A |
A letter. A blank is not allowed. |
! |
A letter that is converted to uppercase during input. A blank is not allowed. |
9 |
A digit. A blank is not allowed. |
(n) |
A number that indicates how many times to repeat the previous format character. |
> |
A leading digit in a numeric value, to be suppressed if the number does not have that many digits. |
< |
Used in conjunction with > to implement
floating-decimal format. The < character (up to 10)
must appear to the right of the decimal and be balanced by an equal or
greater number of > characters left of the decimal.
A digit is displayed in a position formatted with <
when the corresponding > is a leading zero (and the
stored value has the required precision). |
Z |
A leading digit in a numeric value, to be replaced by a blank if the number does not have that many digits. |
* |
A leading digit in a numeric value, to be displayed as an asterisk if the number does not have that many digits. |
, |
A comma in a numeric value greater than
1,000. This is replaced by a period in European format. It is suppressed
if it is preceded by a Z, *, or
>, and the number does not have enough digits to
require the comma. |
. |
A decimal point in a numeric value. This is replaced by a comma in European format. |
+ |
A sign for a positive or negative number
and is displayed accordingly. It can also be used to display a digit
similar to the >, Z, and
* format characters but not when inputting
data. |
– |
For a negative number it is displayed as
–. For a positive number it is suppressed if it is
to the left of the decimal point in the format, and replaced by a blank
if it is to the right. It can also be used to display a digit similar to
the >, Z, and *
format characters but not when inputting data. |
E or e |
A number in scientific notation format. |
CR or cr |
Display negative values with the string "CR" after
it. |
DB or db |
Display negative values with the string "DB" after
it. |
DR or dr |
Display negative values with the string "DR" after
it. |
() |
Display negative values in parentheses. |
You can insert other characters as you wish into formats, and they are
displayed as literal values. For example, the INTEGER value 1234 with
the FORMAT gt;,>>>ABC is displayed as
$1,234ABC.