I have a basic problem with knime
In Germany and 54 other countries is the Numberformat #.###,00 in Knime is it #,###.00
Because of that all numbers read in Knime is in knime Format (like US) also when I change it by replacement the other nodes like String to number don’t recognize it anymore as an number so I think I want to change it in the Preferences but there it is not possible because it is not active because ther is only one format for numbers , double etc.
Hope you know already the Problem and have a easy or complex answer.
Hi @Rwerner !
Regarding String To Number node there is an option for thousand and decimal separator. So define it there and it should work 
Br,
Ivan
3 Likes
Thank you Mlauber but I have to use the Excel Reader, because it is a Excel file with 35 sheets and I do it in a loop which works all fine I need a basic change of the system Format for Numbers
I thought about Preferences but there it is not accessable here a picture
Thank you Ivan It is not working
Why there is no possibility to change the Numberformat to a Country I googled it an half of the world countries have a format with . as thousend seperater and , as dezimal seperater. I am realy wondering why nobady mentioned it before the workaround is not working
I have a number read in by the Excelreader before in excel 1.000,90 output in the reader 1000.9 as double.
I will always have this problem with the numbers there must be a possibility to change the basic number format do you know or know to whome I can adress that?
Hi there!
String to Number node should work. Can you create an example workflow so I can see where do you have error in String To Number node and in general?
Br,
Ivan
1 Like