"String to Number" with negative values

Good Morning :slight_smile:

I would like divide one column by another one. But one of the columns is string and not number. If I would loke to use the node “String to Number” I receive the error message “Values in 3 cells could not be parsed, first error: ‘-1,490,000’ (RowKey: Row9150_?Row34???_?, Position: 23)”.

I assume that KNIME has a problem with the negative value. Do you have any idea how to solve it?

Thank you in advance.


Good morning @daniela02!

Knime doesn’t have a problem with negative values :smiley:

Number -1,490,000 could not be parsed probably because you need to define a thousand separator in String to Number node :wink:


@ipazin: Thank´s for your reply.

I´ve configured
Type: Number
Decimal separator: ,
Thousand separator: .

And receive that error.

But from above error your thousand separator should be comma “,” and not “.” :wink:

1 Like

:see_no_evil: you are right! in Germany it is the other way.

1 Like