2021.2

currencyNoSymbol(value)
Formats a number as a currency whilst omitting the currency symbol.
value
A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float,
SmallCurrency or LargeCurrency.
grouped(value)
Formats a number using a thousands separator. Which separator is used depends on the
Locale, see "Locale" on page787.
value
A number. This can be a value from a field that contains a SmallInteger, BigInteger, Float,
SmallCurrency or LargeCurrency.
Number patterns
Numbers, used in a template and originating from a field in a record set can be displayed using
a custom pattern.
You can enter the pattern via the Text Script Wizard; see "Using the Text Script Wizard" on
page808 and "Formatting variable data" on page812. Note that for this to work, in the
DataMapper the field that contains the value must be set to Integer, Float, or Currency.
In the Script Editor, the pattern can be passed to a function of the formatter; see "formatter" on
page1290. The custom pattern may consist of pattern characters (see below), a prefix and a
suffix.
Note that strings need to be converted to a number before they can be formatted this way.
The repetition of pattern letters determines the exact presentation. For example, the pattern
"00000" limits the number to 5 digits and adds leading zeros to any numbers that are not 5
digits long.
Pattern characters
Symbol Location Localized? Meaning
Page 1317