ddbicon.pngOutput Mask


Define the column's print and display format mask. The following mask characters can be used:

 

Character

Description

B

Inserts a space character.

CR

Inserts the "CR" string if the number is negative, or two spaces if the number is positive.

DR

Inserts the "CR" string if the number is negative, or the "DR" string if the number is positive.

0

Replaces characters with digits (i.e., 0..9).

#

Suppresses leading zeros. Replaced by a fill character for leading zeros to the left of the decimal point. Replaced by a space character for trailing zeros to the right of the decimal point. Any other time it is replaced by a digit.

*

Inserts an asterisk character.

,

Inserts a fill character to the left of the decimal point if no digits have been placed. Otherwise, it inserts a comma into the result.

.

Inserts a decimal point if any characters have been placed, otherwise, it inserts a fill character. After the decimal point, it replaces the fill character with a space character.

(

Inserts a left parentheses if the number is negative, or the fill character if the number is positive.

)

Inserts a right parentheses if the number is negative, or a fill character if the number is positive.

-

Displays a minus sign if the number is negative, or a space character if the number is positive.

+

Displays a plus sign if the number is positive, or a minus sign if the number is negative.

$

Displays a dollar sign ($).