Removing Letters From String

Hi All,

Last post today. Trying to convert Alteryx workflows over to KNIME and already hit a roadblock. I have string data that is alphanumeric. 123AJC, 4865ZHD for example. I want to do data cleansing on the column and remove all letters in addition to all white space. I cannot find anywhere that explains how to do this (remove non-numeric characters from a string).

Any help is greatly appreciated as this is something I need to do quite often.

Use regexReplace function
In Column Expression or String Manipulation nodes.


@izaychik63 Thank you so much!

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