Removing Unwanted Digits in a Row

[sscheiten]

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.

Thanks!

[bruno29a]

Hi @sscheiten and welcome to the Community.

Does this work for you?

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

[sscheiten]

Thank you so much! That worked like a charm.

[ipazin]

Hello there,

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

removeChars( $yourColumn$, "0123456789")

Br,
Ivan

[Daniel_Weikert]

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