Formats a number in a locale-specific currency format. For countries that use the euro, the result depends on the JVM.
1 | LSCurrencyFormat(number [, type, locale]) |
LSEuroCurrencyFormat, LSIsCurrency, LSParseCurrency, LSParseEuroCurrency, SetLocale; Handling data in ColdFusion in the Developing ColdFusion Applications
ColdFusion 8: Added the locale parameter.
ColdFusion MX: Changed formatting behavior: this function might return different formatting than in earlier releases. If a negative number is passed to it, it returns a negative number. If type = "local", it returns the value in the current locale's standard format. If type = "international", it returns the value in the current locale's international standard format. This function uses Java standard locale formatting rules on all platforms.
Parameter |
Description |
|---|---|
number |
Currency value |
type |
|
locale |
Locale to use instead of the locale of the page when processing the function |
Note:
With a Sun 1.3.1-compliant JVM, use the LSEuroCurrencyFormat function to format euro currency values.
The following table shows sample currency output. For locales that use Euro, the Local and International columns contains two entries. The first is entry is the result with a Sun the 1.4.1 or later compliant JVM, the second entry is the result with a 1.3.1-compliant JVM.
Locale |
Type = Local |
Type = International |
Type = None |
|---|---|---|---|
Chinese (China) |
100,000.00 |
CNY100,000.00 |
100,000.00 |
Chinese (Hong Kong) |
HK$100,000.00 |
HKD100,000.00 |
100,000.00 |
Chinese (Taiwan) |
NT$100,000.00 |
TWD100,000.00 |
100,000.00 |
Dutch (Belgian) |
100.000,00 - 100.000,00 BF |
BEF100.000,00EUR100.000,00 |
100.000,00 |
Dutch (Standard) |
100.000,00fl 100.000,00 |
NLG100.000,00EUR100.000,00 |
100.000,00 |
English (Australian) |
$100,000.00 |
AUD100,000.00 |
100,000.00 |
English (Canadian) |
$100,000.00 |
CAD100,000.00 |
100,000.00 |
English (New Zealand) |
$100,000.00 |
NZD100,000.00 |
100,000.00 |
English (UK) |
100,000.00 |
GBP100,000.00 |
100,000.00 |
English (US) |
$100,000.00 |
USD100,000.00 |
100,000.00 |
French (Belgian) |
100.000,00 - 100.000,00 FB |
EUR100.000,00BEF100.000,00 |
100.000,00 |
French (Canadian) |
100 000,00 $ |
CAD100 000,00 |
100 000,00 |
French (Standard) |
100 000,00 - 100 000,00 F |
EUR100 000,00FRF100 000,00 |
100 000,00 |
French (Swiss) |
SFr. 100'000.00 |
CHF100'000.00 |
100'000.00 |
German (Austrian) |
100.000,00-S 100.000,00 |
EUR100.000,00ATS100.000,00 |
100.000,00 |
German (Standard) |
100.000,00 - 100.000,00 DM |
EUR100.000,00DEM100.000,00 |
100.000,00 |
German (Swiss) |
SFr. 100'000.00 |
CHF100'000.00 |
100'000.00 |
Italian (Standard) |
100.000,00L. 10.000.000 |
EUR10.000.000ITL10.000.000 |
10.000.000 |
Italian (Swiss) |
SFr. 100'000.00 |
CHF100'000.00 |
100'000.00 |
Japanese |
100,000 |
JPY100,000 |
JPY100,000 |
Korean |
W100,000 |
KRW100,000 |
100,000 |
Norwegian (Bokmal) |
kr 100 000,00 |
NOK100 000,00 |
100 000,00 |
Norwegian (Nynorsk) |
kr 100 000,00 |
NOK100 000,00 |
100 000,00 |
Portuguese (Brazilian) |
R$100.000,00 |
BRC100.000,00 |
100.000,00 |
Portuguese (Standard) |
100.000,00 - R$100.000,00 |
EUR100.000,00BRC100.000,00 |
100.000,00 |
Spanish (Mexican) |
$100,000.00 |
MXN100,000.00 |
100,000.00 |
Spanish (Modern) |
100.000,00 - 10.000.000 Pts |
EUR10.000.000ESP10.000.000 |
10.000.000 |
Spanish (Standard) |
100.000,00 - 10.000.000 Pts |
ESP10.000.000EUR10.000.000 |
10.000.000 |
Swedish |
100.000,00 kr |
SEK100.000,00 |
100.000,00 |
ColdFusion maps Spanish (Modern) to the Spanish (Standard) format. |
To set the default display format of date, time, number, and currency values, use the SetLocale function.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | <h3>LSCurrencyFormat Example</h3> <p>LSCurrencyFormat returns a currency value using the locale convention. Default value is "local."<!--- loop through list of locales; show currency values for 100,000 units ---><cfloop LIST = "#Server.Coldfusion.SupportedLocales#"index = "locale" delimiters = ","> <cfset oldlocale = SetLocale(locale)> <cfoutput><p><b><I>#locale#</I></b> Local: #LSCurrencyFormat(100000, "local")# International: #LSCurrencyFormat(100000, "international")# None: #LSCurrencyFormat(100000, "none")# <hr noshade> </cfoutput> </cfloop> |
Twitter™ and Facebook posts are not covered under the terms of Creative Commons.