Quick Recipes

  • 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.