string manipulation

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 to Number node has thousand separator parameter.

Thanks! I should have checked it more carefully.

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