String to Number

Hi,
i tried to change the “PVO” in my Excell Table from String to Number, but when i use “String to Number” node, all the results are missing values. could someone help me ?

this is my workflow
KNIME_project.knwf (74.1 KB)

thanks

Br,

Hussein

You need to get rid of currency sign and dashes first.

2 Likes

Hi, the most easy way is for you to do some string manipulation , use the replaceChars function for each price or do a loop through the columns.

replaceChars (PVOcolmnhere,“€, -”,"")

this will replace the euro, comma space and dash signs with nothing, then you can convert to number.

hope it helps.

1 Like