Convert number formats¶
Convert numbers from one language/country-specific format to another.
Options¶
Column
Convert numbers in the following columns:
A single column
An explicit list of columns
All columns matching a regex pattern
All columns
Input format
Number format of input column(s). Decimal numbers are stored in the raw format. Supported formats:
Raw: 1234567890.123 (required format for numeric columns fed to other DSS mechanisms)
French: 1 234 567 890,123 (also: Canadian, Danish, Finnish, Swedish)
English: 1,234,567,890.123 (also: Thai)
Italian: 1.234.567.890,123 (also: Norwegian, Spanish)
Swiss: 1’234’567’890.123
Output format
Number format of output column(s). See supported formats above.