Format as Currency directive

The FORMAT-AS-CURRENCY is a directive for formatting a number as a currency as specified by the locale.

Syntax

format-as-currency :source :destination ['locale']

The source specifies the name of the column that contains number to be converted to currency as specified by locale. The destination contains the formatted value of currency as string. Optional locale specifies the locale to be used for formatting the number as string representation of currency in the source column.

Usage Notes

FORMAT-AS-CURRENCY can be used to format a number representing currency into a locale currency. If locale is not specified in the directive, a default of 'en_US' is assumed.

When the directive is unable to parse the currency, an error record is generated.

Following are few examples of parsing currency into number.

format-as-currency :src :dst
format-as-currency :src :dst 'en_US'
format-as-currency :src :dst 'en_IE'
format-as-currency :src :dst 'pl_PL'
format-as-currency :src :dst 'ca_ES'
format-as-currency :src :dst 'es_ES'
format-as-currency :src :dst 'es_CO'
format-as-currency :src :dst 'de_CH'
format-as-currency :src :dst 'en_ZA'
format-as-currency :src :dst 'en_GB'
format-as-currency :src :dst 'fr_BE'