Hi. I have developed a component that converts selected numeric columns to String by specifying a locale. The locale controls the characters used for things like thousands separator, decimal separator, etc. Additionally, a decimal format pattern can be used for finer control of the output format (number of decimal places, whether to use scientific notation, currency formats, etc.).
I have supplied a number of predefined formats. Please give it a try and provide feedback if you are so inclined. Any suggestions for improvement appreciated.
Thanks,
Don
Here’s the dialog of the component:
Number To String (Locale).knwf (39.0 KB)