Removing Letters From String

[TardisPilot]

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.

[izaychik63]

Use regexReplace function

In Column Expression or String Manipulation nodes.

[TardisPilot]

@izaychik63 Thank you so much!