String to number node not parsing

owd · August 16, 2021, 7:24am

Hi,
I am currently using the string to number node to convert a column with $ from strings to number but it shows the cells could not be parsed.

May I know how to rectify this please?

ipazin · August 16, 2021, 9:13am

Hello @owd,

and welcome to KNIME Community!

String to Number node can’t parse currency symbols. You can remove $ with substr() function from String Manipulation node - substr( yourColumn, 1) and then use String to Number node.

Br,
Ivan

HansS · August 16, 2021, 9:30am

Hi @owd

And if you add toDouble => toDouble( substr( $yourColumn$, 1)) you don’t need te String to Number node.
gr. Hans

system · February 14, 2022, 9:30pm

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