Hitachi Vantara Pentaho Community Wiki
Access Keys:
Skip to content (Access Key - 0)

  • How to import numbers in the European number formatThe number format when importing from a CSV file in Kettle is english-based, meaning that in order to parse a number (12.345.678,99) the format must still be '#,##0.00' with the decimal and group characters set to '.' and ',' to match the European format. Number formatting is done as in the Java Number Classes.

This documentation is maintained by the Pentaho community, and members are encouraged to create new pages in the appropriate spaces, or edit existing pages that need to be corrected or updated.

Please do not leave comments on Wiki pages asking for help. They will be deleted. Use the forums instead.

Adaptavist Theme Builder Powered by Atlassian Confluence