Hi. Am I correct to assume you would like to format numbers such that the ‘thousands separator’ should be an apostrophe instead of a comma? For example how they format numbers in Switzerland?
Here’s a quick and dirty solution using Java. (I created a metanode you can copy into your own workflow and configure). Import the attached .knwf file into your KNIME desktop explorer.
The metanode can be configured with the column of (double) numbers you want to format, and the formatting pattern string (see http://tutorials.jenkov.com/java-internationalization/decimalformat.html#number-format-pattern-syntax for pattern syntax). Although the thousands separator is specified with a comma in the pattern, it will be replaced with apostrophe in the output.
Example output:
custom decimal format.knwf (14.2 KB)
-Don