Selecting an Extended Currency Symbol

Reference:

You can select a currency symbol for display in report output regardless of the default currency symbol configured for National Language Support (NLS). Use the extended currency symbol format in place of the floating dollar (M) or non-floating dollar (N) display option. When you use the floating dollar (M) or non-floating dollar (N) display option, the currency symbol associated with the default code page is displayed. For example, when you use an American English code page, the dollar sign is displayed.

Note: You can use the SET CURRSYMB command to control which symbol displays for the M and N options.

The extended currency symbol format allows you to display a symbol other than the dollar sign. For example, you can display the symbol for a United States dollar, a British pound, a Japanese yen, or the euro. Extended currency symbol support is available for numeric formats (I, D, F, and P).

Use the following character combinations as the final two characters in any numeric display format:

Display Option

Description

Example

!d

Fixed dollar sign.

D12.2!d

:d

Fixed dollar sign.

D12.2:d

!D

Floating dollar sign.

D12.2!D

:D

Floating dollar sign.

D12.2:D

!e

Fixed euro symbol.

F9.2!e

:e

Fixed euro symbol.

F9.2:e

!E

Floating euro symbol on the left side.

F9.2!E

:E

Floating euro symbol on the left side.

F9.2:E

!F

Floating euro symbol on the right side.

F9.2!F

:F

Floating euro symbol on the right side.

F9.2:F

!l

Fixed British pound sign.

D12.1!l

:l

Fixed British pound sign.

D12.1:l

!L

Floating British pound sign.

D12.1!L

:L

Floating British pound sign.

D12.1:L

!y

Fixed Japanese yen symbol.

I9!y

:y

Fixed Japanese yen symbol.

I9:y

!Y

Floating Japanese yen symbol.

I9!Y

:Y

Floating Japanese yen symbol.

I9:Y

Note: The colon (:) is equivalent to the exclamation point (!), however, only the colon is invariant across code pages, so using the colon is recommended.

Reference: Extended Currency Symbol Formats

The following guidelines apply:

  • A format specification cannot be longer than eight characters.
  • The extended currency option must be the last option in the format.
  • The extended currency symbol format cannot include the floating (M) or non-floating (N) display option.
  • A non-floating currency symbol is displayed only on the first row of a report page. If you use field-based reformatting (as in the example that follows) to display multiple currency symbols in a report column, only the symbol associated with the first row is displayed. In this case, do not use non-floating currency symbols.
  • Lowercase letters are transmitted as uppercase letters by the terminal I/O procedures. Therefore, the fixed extended currency symbols can only be specified in a procedure.
  • Extended currency symbol formats can be used with fields in floating point, decimal, packed, and integer formats. Alphanumeric, dynamic, and variable character formats cannot be used.

Information Builders