2018.1

page671 and "Formatting variable data" on page675. 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1059. 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
0 Number Text Digit
# Number Year Digit, zero shows as absent
. Number Year Decimal separator or monetary decimal separator
- Number Month Minus sign
, Number Number Grouping separator
E Number Number Separates mantissa and exponent in scientific
notation. Need not be quoted in prefix or suffix.
; Subpattern
boundary
Number Separates positive and negative subpatterns
% Prefix or
suffix
Number Multiply by 100 and show as percentage
\u2030 Prefix or
suffix
Number Multiply by 1000 and show as per mille value
Page 1073