Error String to Number

[lat_azy]

Hi:

I’m new to KNIME. I’m preparing the workflow for a Rule Association Analysis, and thus trying to convert string to number, but it keeps showing the same error.

This is the workflow till now

I already updated the thousands and decimal separator, but still doesn’t work
Could you please help me? Thanks!

[HansS]

Hi @lat_azy

Welcome to the KNIME Forum. It looks like there are white-spaces in your “string-numbers”. Try a String Manipulation node to remove al space characters.
.
gr. Hans

[qqilihq]

Beside that, the decimal separator seems wrong – . vs ,

–Philipp

[lat_azy]

Hi! How can I change the separator. I tried with replacer node but didn’t work. Thanks!

[lat_azy]

UPDATE:
Thanks. I could change it using the same node String Manipulation

[qqilihq]

This one you can simply configure in the String to Number dialog. There’s an input which literally says “Decimal separator”