I have a value being passed in XML that is 37350.000000. I need to show this as currency in German format. I can leave it as text and st the script to ‘Currency No Symbol’ but that just gives me 37,350.00. The proper German format is 37.350,00. How can I get this result?
Hi j_r_smith,
I added a extract step to my data mapper which created a field with the value you posted above. In the data mapper I set that fields type to currency. Decimal separator to ‘.’ (without quotes), set Thousand separator to ‘,’ (comma only). In the designer I added a positioned box and dragged the field from the data model to it. That creates a text script. In the text script I set the fields format to Currency No Symbol. In designer go to Edit menu and then click on Locale. Change Use to Explicit Locale and Locale to de.
Result is 37.350,00
Regards,
S
Thank You! For the life of me I could not remember where that locale setting was!