Number To String (Locale)

Converts selected number columns to string columns formatted according to a specified locale (e.g. country). The locale provides conventions such as the characters used to separate thousands groups, the currency symbol, and the character used to specify the decimal.

In addition to the conventions provided by the locale, a 'format pattern' is specified and allows for fine control of the format (for example, the number of decimal places to show, whether to use scientific notation, whether to display a currency symbol, etc.) You can select one of the predefined format patterns or specify a custom pattern. The specification of the pattern is defined by the DecimalFormat Java class.

From http://tutorials.jenkov.com/java-internationalization/decimalformat.html#number-format-pattern-syntax
You can use the following characters in a custom formatting pattern:

0 A digit - always displayed, even if number has less digits (then 0 is displayed)
# A digit, leading zeroes are omitted.
. Marks decimal separator
, Marks grouping separator (e.g. thousand separator)
E Separates mantissa and exponent for exponential formats.
; Separates positive and negative subpatterns
- Marks the negative number prefix
% Multiplies by 100 and shows number as percentage
‰ Multiplies by 1000 and shows number as per mille
¤ Currency sign - replaced by the currency sign for the Locale. Also makes formatting use the monetary decimal separator instead of normal decimal separator. ¤¤ makes formatting use international monetary symbols.
X Marks a character to be used in number prefix or suffix
' Marks a quote around special characters in prefix or suffix of formatted number.

Official Java documentation: https://docs.oracle.com/javase/8/docs/api/java/text/DecimalFormat.html
Locales are accurate as of Java 1.8.0_252
Disclaimer: This component is believed to operate correctly, but the developer offers no warranty and bears no responsibility for consequences resulting from its use.

Input ports

1. Type: Table
   Port 1
   Table containing one or more numeric columns to convert to formatted string columns

Output ports

1. Type: Table
   Port 1
   Table containing formatted string columns