Remove all characters except numbers

KNIME Analytics Platform
1

Hi team,

I am facing a problem while converting string to number. I have Few columns with numbers starting with inverted comma. Hence I want to remove all the characters other than numbers in the column and then apply string to column node.

Does anyone know how i could remove all characters except numbers from columns.

Thanks in advance!

Best Regards,
Sahil

2

Hi,

You could use the “String Manipulation” node with this expression:
regexReplace($column_name$, "[^0-9.]", "")
This expression will remove any characters other than numbers.

Best,
Armin

7 Likes
3

Thank you Armin, I forgot to mention dot(.) for decimals. Could you tell me how to modify this regex to include dot also.

Thanks again.!

Best Regards,
Sahil

1 Like
4

I have edited the expression in my first reply. (a dot is added to the character set)

Good luck

1 Like
5

Thank you so much, Armin. This is exactly i was looking for!

Best regards,
Sahil

6

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