# How do I remove truncated string ? **URL:** \ **Category:** KNIME Analytics Platform\ **Created:** [May 28, 2019, 1:37am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316 "2019-05-28T01:37:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gua\_gunners](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gua_gunners/32/4939_2.png) [@gua\_gunners](https://forum.knime.com/u/gua_gunners)\ **Post date:** [May 28, 2019, 1:37am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/1 "2019-05-28T01:37:33Z")
Can anyone suggest or help me how can I filter out string data with truncated values. ![truncateddd](https://forum-cdn.knime.com/uploads/default/original/2X/6/6f521815d6128ae8aa9fa158eef224e32deb3529.png) ---
**Author:** ![quaeler](https://forum-cdn.knime.com/user_avatar/forum.knime.com/quaeler/32/3944_2.png) [@quaeler](https://forum.knime.com/u/quaeler)\ **Post date:** [May 28, 2019, 3:29am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/2 "2019-05-28T03:29:05Z")
I’m guessing you’re asking how you can filter out rows whose string values in a given column have an ellipsis? The easiest way, if so, would probably to use the Row Filter node, specifying the regex to match on; there is actually an ellipsis character `…` as opposed to three periods `...` so you’ll need to determine which to include in your regex. ---
**Author:** ![gua\_gunners](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gua_gunners/32/4939_2.png) [@gua\_gunners](https://forum.knime.com/u/gua_gunners)\ **Post date:** [May 28, 2019, 3:53am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/3 "2019-05-28T03:53:36Z")
Yeahh…you can put it that way. Some of the tweets have those elipsis and some arent (You can refer to the image down below). I have been using string manipulation node, row filter node…it works but some data have been missed to be filter out. I havent try Regex yet, okay @quaeler thank you for the suggestion. ![neww](https://forum-cdn.knime.com/uploads/default/original/2X/3/3a07e8610b5fe641543a3522adbf0ebb84137d68.png) ---
**Author:** ![ScottF](https://forum-cdn.knime.com/user_avatar/forum.knime.com/scottf/32/61316_2.png) [@ScottF](https://forum.knime.com/u/ScottF)\ **Post date:** [May 28, 2019, 3:33pm UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/4 "2019-05-28T15:33:32Z")
In this case, since we know that the truncated tweets are due to a bug in the Twitter implementation with retweets (see previous discussion [here](https://forum.knime.com/t/twitter-timeline-limited-to-140-characters/13080/5)), you might be able to filter based on strings starting with “RT” that are 140 characters long. ---
**Author:** ![gua\_gunners](https://forum-cdn.knime.com/user_avatar/forum.knime.com/gua_gunners/32/4939_2.png) [@gua\_gunners](https://forum.knime.com/u/gua_gunners)\ **Post date:** [May 29, 2019, 2:16am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/5 "2019-05-29T02:16:52Z")
Thanks @ScottF for the help. I hope that your KNIME Team Member can fix this bug asap. This will mean so much to me 😊 ---
**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:** [May 29, 2019, 12:24pm UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/6 "2019-05-29T12:24:40Z")
Hi, It is fixed and the fix should go out with the next summer release of KNIME Analytics Platform. Br, Ivan ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [November 28, 2019, 12:34am UTC](https://forum.knime.com/t/how-do-i-remove-truncated-string/15316/7 "2019-11-28T00:34:12Z")
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.