How can i convert Strings to numbers

Hi all!

I've got a problem to transform a string column in numbers.

I used the String Manipulation node to extract the dollar sign and also tried to use  String to Number node. noth didn't work.

Any help?

Best

 

Try removing also the thousands separator (the comma). Just replace it with nothing.

Cheers,
Marco.

Hi Fabio,

check the configuration dialog, there are all the configurations you need.

Best, Iris

Hi!
Worked as follow:

To extract the $
1-String Manipulation: replaceChars($Balance$,"$" ,"" )

To extract the ,
2-String Manipulation: replace($Balance-\$$,"," ,"" )

...and them To String to Number.

Thanks again!!!!