# Can we filter the text which is mostly same?

**URL:** <https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570>\
**Category:** KNIME Analytics Platform\
**Tags:** text-processing\
**Created:** [February 9, 2021, 2:52pm UTC](https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570 "2021-02-09T14:52:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![PankajChaudhary](https://forum-cdn.knime.com/user_avatar/forum.knime.com/pankajchaudhary/32/18275_2.png) [@PankajChaudhary](https://forum.knime.com/u/PankajChaudhary)\
**Post date:** [February 9, 2021, 2:52pm UTC](https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570/1 "2021-02-09T14:52:14Z")

</div>

I have a table like this  
 ![Screenshot 2021-02-09 201844](https://forum-cdn.knime.com/uploads/default/original/3X/9/f/9f5367b701e8460fcf7190b423e9aefd011fec8e.png)

When I am using Group By node on S.no and Name  
it is given table like this  
 ![Screenshot 2021-02-09 202058](https://forum-cdn.knime.com/uploads/default/original/3X/5/e/5eef39835037c02623c7c325a71269f4b64318b4.png)

but I need only two rows for that it should merge the same look like Name  
Can we do that in KNIME?

---

<div class="post-metadata">

**Author:** ![Snowy](https://forum-cdn.knime.com/user_avatar/forum.knime.com/snowy/32/963_2.png) [@Snowy](https://forum.knime.com/u/Snowy)\
**Post date:** [February 9, 2021, 5:30pm UTC](https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570/2 "2021-02-09T17:30:03Z")

</div>

If the issue just appears to be a ‘.’, then you could run the String Manipulation node prior to the Group By with:  
replace(column,".","")  
Or if it’s multiple characters, you could use the replaceChars() function.

I think the above would be the most simple solution. If your dataset is more complex, please share some of the nuances and we can help find the appropriate solution.

---

<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:** [February 9, 2021, 7:24pm UTC](https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570/3 "2021-02-09T19:24:00Z")

</div>

There is a string similarity node in KNIME. Maybe that helps  
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:** [August 11, 2021, 7:24am UTC](https://forum.knime.com/t/can-we-filter-the-text-which-is-mostly-same/30570/4 "2021-08-11T07:24:20Z")

</div>

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