# Removing Unwanted Digits in a Row

**URL:** <https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637>\
**Category:** KNIME Analytics Platform\
**Created:** [July 15, 2021, 2:06am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637 "2021-07-15T02:06:27Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![sscheiten](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/ac8455/32.png) [@sscheiten](https://forum.knime.com/u/sscheiten)\
**Post date:** [July 15, 2021, 2:06am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/1 "2021-07-15T02:06:28Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![bruno29a](https://forum-cdn.knime.com/user_avatar/forum.knime.com/bruno29a/32/28802_2.png) [@bruno29a](https://forum.knime.com/u/bruno29a)\
**Post date:** [July 15, 2021, 4:55am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/2 "2021-07-15T04:55:45Z")

</div>

Hi @sscheiten and welcome to the Community.

Does this work for you?  
 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/a/d/ade8f47ddedce59d7dd1d5f3da7006d108b30b3c.png)

Here’s the workflow:  
[remove digits.knwf](https://forum.knime.com/uploads/short-url/5On2hPIk6FHGG5bCzTl0oACAZw1.knwf) (6.1 KB)

---

<div class="post-metadata">

**Author:** ![sscheiten](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/ac8455/32.png) [@sscheiten](https://forum.knime.com/u/sscheiten)\
**Post date:** [July 16, 2021, 12:04am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/3 "2021-07-16T00:04:10Z")

</div>

Thank you so much! That worked like a charm.

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [July 16, 2021, 10:51am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/4 "2021-07-16T10:51:58Z")

</div>

Hello there,

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

`removeChars( $yourColumn$, "0123456789")`

Br,  
Ivan

---

<div class="post-metadata">

**Author:** ![Daniel\_Weikert](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/e47c2d/32.png) [@Daniel\_Weikert](https://forum.knime.com/u/Daniel_Weikert)\
**Post date:** [July 16, 2021, 4:20pm UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/5 "2021-07-16T16:20:03Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [January 15, 2022, 4:20am UTC](https://forum.knime.com/t/removing-unwanted-digits-in-a-row/34637/6 "2022-01-15T04:20:41Z")

</div>

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