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
In this standard, 3e2 represents three times ten raised to the power of two, or 300.