Depending on the countries, numbers may have different formats. Here are the
different formats used in Talend Data Preparation.
| Format | Description | Thousands separator | Decimal separator |
|---|---|---|---|
| 1,545.12 (US, UK, China, etc...) | This standard is mainly used in English-speaking countries and other countries such as China. | comma | period |
| 1 545,12 (France, Russia, etc...) | This standard is mainly used in non English-speaking countries. | space | comma |
| 1'545,12 (Swiss) | This standard is used in Switzerland. | apostrophe | comma |
| Scientific | This standard is used to write numbers using scientific
notation. In this standard, 3e2 represents three times ten raised to the power of two, or 300. |
comma | period |