Removing Unwanted Digits in a Row

Hi everyone! New to Knime and I ran into an issue when taking data where some rows have errors in them. In this case the row has student names, for example, “Jane Doe.” Some of the rows erroneously have digits after the name, for example “Jane Doe 1999.” How do delete the digits from the string? I would like to do this across a few rows where there are errors.

I think it is something to do with the row filter pattern matching, but I am having trouble with the syntax of the pattern.


Hi @sscheiten and welcome to the Community.

Does this work for you?

Here’s the workflow:
remove digits.knwf (6.1 KB)


Thank you so much! That worked like a charm.

1 Like

Hello there,

removeChars() function can be useful as well in such cases.

removeChars( $yourColumn$, "0123456789")



Thanks @ipazin ,
always interesting to see that there is more then one way to skin the cat

1 Like

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