currency format problem in string to number node

[Paddymaster]

Hi,

I want to change a String format to Number format.
e.g
String 111.111,22

If i change the String to Number (Double) i get 111,111.22
My settings are in the picture

My Problem is the format. I need a german format like 111.111,22 in Double.

[ipazin]

Hi there @Paddymaster,

Currently this is not possible. I will add +1 on request.

Check this topics for more info and possible workarounds:

Change standard decimal separator

Hello,   how can I change the standard decimal seperator from '.' to ',' in KNIME? Output is not correctly recognized in excel, changing my language settings to english is no solution for me.   Thanks for your help.

Wrong decimal seperator

Hi everyone, I’am dealing with an issue about the decimal seperator in Knime. I have a lot of data (550 colomns) with a wrong decimal seperator. For example, I have average price and size, witch have a decimal point seperator. So I would like to convert this decimal point with a comma seperator. But I have too much columns to do one after one. There must be a solution, but I don’t find. Thank for your help.

Br,
Ivan