String to Number Challenge

[mcaraffini]

Hi Knime Community!
I’m trying to convert a column to Double from String. However, some values use “.” as decimal separator and “,” as thousand separator (and others vice versa).

For example:
1.555,80
8,190.00
1,130
1.450
1 560.23

Do you have any clues on how to fix it?
Thank you!

[k10shetty1]

Hi @mcaraffini,

I built this workflow with the help of expression node, and tried all the different combinations and it is working fine. Let me know if it solves your issue.

Best,
Keerthan

[mcaraffini]

Thank you! It looks amazing! I managed as well to do it with much more nodes, so I’ll definitely use yours!