Convert Number Format to French

[TSled]

Hello, is there an easy way to convert number/currency formats to different language standards without a complex script? Specifically I’m looking for something to go from English and French. Example is below:
$1,234,567 → 1 234 567 $
$1,000 → 1 000 $

I’m looking to do this in the designer template, but will do it in the datamapper if needed.

Thanks for the help

Thank you,

[Erik]

This is achieved by setting the Locale for the document (choose Edit > Locale), this handles formatting for numbers (including currencies) and dates. You can set a specific local or use one provided via the data (as described in the linked post).

The following screenshot shows the Locale dialog (set to fr-FR). I used an expression with the “currency” helper to apply the currency format to the “price” data field ({{currency price}})

Hope this helps,

Erik

PS1. Recently described dynamically setting the Locale here:

date format output based on data file

Hi ahaddad, To achieve this, you can set the Locale for the document based on the data field. The locale is a setting that can affect date, time and currency output. This assumes the value is the proper language code (like “es-pr” or “es”). You can prob prepend your value with “es-” in the Data Mapping configuration. Here’s how you can set the locale: Go to Edit > Locale, which opens the Locale dialog. Set “Use” to “Data Field” and select the appropriate data field from the dropdown. [imag…

PS2. Formatting can also be applied via the Scripting API.

[TSled]

This is great, thank you Erik!