2022.2

value
Anumber.ThiscanbeavaluefromafieldthatcontainsaSmallInteger,BigInteger,Float,SmallCur-
rencyorLargeCurrency.
pattern
Acustompatternthatmayconsistofsymbols;see"Numberpatterns"below.Notethattherepetitionof
patternlettersplaysapartindeterminingtheexactpresentation.
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,SmallCur-
rencyorLargeCurrency.
grouped(value)
Formatsanumberusingathousandsseparator.WhichseparatorisuseddependsontheLocale,see
"Locale"onpage706.
value
Anumber.ThiscanbeavaluefromafieldthatcontainsaSmallInteger,BigInteger,Float,SmallCur-
rencyorLargeCurrency.
Numberpatterns
Numbers,usedinatemplateandoriginatingfromafieldinarecordsetcanbedisplayedusingacus-
tompattern.
Youcanenterthepatterninanexpression(see"FormatHelpers"onpage769),orintheHelperWizard
orTextScriptWizard(see"UsingtheHelperWizard"onpage725,"UsingtheTextScriptWizard"on
page729and"Formattingvariabledata"onpage732).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1175.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 1196