string manipulation

KNIME Analytics Platform
#1

I wanted to remove the * in some cells and then convert the columns to numbers. I used string manipulation “ReplaceChar” to remove the * from columns one by one. Probably it is not the best approach but it did the job. However, when I used the “string to number” node, the numbers with thousand separators (,) was converted to missing value. How I can solve this problem?

Thank you for your time.

string%20manipulation
string%20manipulation1018×706 53.6 KB

#2

String to Number node has thousand separator parameter.

#3

Thanks! I should have checked it more carefully.

#4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.