C. Data Format Templates : Numeric Templates : Numeric Template Syntax : Special Template Characters
 
Share this page                  
Special Template Characters
The following table describes the special template characters:
Code
Description
n
If a digit remains in the number, display the digit. If no digits remain, display zero.
z
If a digit remains in the number, display the digit. If no digits remain, display a space.
This code is used for standard blank-padded numeric fields.
$
If a digit remains in the number, display the digit. If no digits remain, display a floating dollar sign immediately to the left of the last digit. If a dollar sign has already been displayed, display a space.
This code can be used to display a dollar sign directly to the left of the number or to place a dollar sign in a fixed position in the field.
If a digit remains in the number, display the digit. If no digits are left and the number is negative, a floating minus sign is displayed immediately to the left of the last digit. If a minus sign has already been displayed, a space is inserted. If the number is positive, a space is inserted.
+
If a digit remains in the number, display the digit. If no digits are left, display a floating sign (+ or –) to the left of the last digit. If one has already been displayed, display a space.
,
If a digit remains in the number, display a comma in this position. If no digits remain, display a space.
This code is used for inserting commas to break up large numbers.
Note:  If the II_DECIMAL environment variable is set to a comma, then a comma in the template displays a period. For more information, see Environment Variables for All Platforms (see Environment Variables for All Platforms).
.
Display the decimal point in this spot.
Note:  If the II_DECIMAL environment variable is set to a comma, then a comma in the template displays a period. For more information, see Environment Variables for All Platforms (see Environment Variables for All Platforms).
*
If no digits remain, display an asterisk.
This code is useful for filling a number on the left with asterisks (for example, for checks).
^
If a digit remains in the number, display the digit, but round up the digit according to the values of the digits to the right of this position.
space
If a digit remains in the number, displays a blank space in this position.
Using this code is equivalent to specifying a backslash followed by a space.
CR
(two
characters)
If the number is negative, insert the characters CR (for credit). If the number is positive, display two blanks.
You can specify the characters in uppercase or lowercase (or one of each).
DB
(two
characters)
If the number is negative, insert the characters DB (for debit). If the number is positive, display two blanks.
You can specify the characters in uppercase or lowercase (or one of each).
\c
Any character, c, preceded by a backslash is printed in the position specified.
This code lets you insert characters such as hyphens and slashes into a template.
( ), [ ],{ },
< >
If the number is negative, displays it within the specified symbols.
Note:  The floating symbols ($, +, and –) are displayed only once in the field. If a field is specified without “n” in the numeric positions and a value of zero is encountered, the field is blanked.