"String to Number" with negative values

KNIME Analytics Platform
1

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.

BR
Daniela

2

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:

Br,
Ivan

3

@ipazin: Thank´s for your reply.

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

And receive that error.

4

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

1 Like
5

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

1 Like