Hi,
I want to convert column Wochenstunden from string to number. It contains some values like
22.5
25.2
9.5
I have tried string to number with . as the decimal separator but so far it is impossible. The error says “WARN String To Number 0:462 Values in 3 cells could not be parsed, first error: ‘9.5’ (RowKey: 31.03.2022 10:35:34 (#1253)??, Position: 20)”.
I really appreciate if anyone can support.
Welcome to the forum @ThaoN.
I have tried string to number with . as the decimal separator but so far it is impossible. The error says “WARN String To Number 0:462 Values in 3 cells could not be parsed, first error: ‘9.5’ (RowKey: 31.03.2022 10:35:34 (#1253)??, Position: 20)”.
This would be easier to troubleshoot if you shared your data and/or your workflow.
The 3 cells that could not be parsed, what do they contain?
Hi elsamuel
This is my data with and the value in column Wochenstunden that i want to covert to number.
I import the data from a gsheet.
In the future, it would be better if you shared the data as a csv file or equivalent. Uploading the workflow would be a welcome addition. With a screenshot we’re quite limited in what we can do here.
The reason I asked for the data was to see
Having looked at the screenshot, I’m assuming that the problem values are the ones with decimal points that you listed in your initial post.
How is the String to Number node configured? It seems to me that you may be trying to convert to integers instead of double-precision floating-point numbers.
I actually don’t have the option to choose double-precision floating-point numbers in my String to Number node. The data before that node is attached here.
Thank you for your support.
Test.xlsx (48.5 KB)
Use Number (double) as the Type.
As a last option use string manipulation to replace . with comma and convert afterwards
It works magically 
Thanks a lot!!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
