Hello, i have a quick question
if i want to remove all rows which contain “word + “new york”” in a column, what should i do?
Column
pizza new york
pizza chicago
pizza paris
burger new york
Remove 1 and 4 . I already tried this one, but it just works for “new york” as one word
and if this works, how can i implement a CSV of words which will be filtered out?
Thx for your help
Hi @phil21oo & welcome to the KNIME forum!
You were almost there. You need to check the “contains wild cards” option and use instead the following pattern machine: *new york*
the *
sign is a wild card that means -any possible chain of characters - included an empty string.
Hope it helps
Cheers
Ael
3 Likes
Thank you very much, this works
and how can i implement a CSV of words which will be filtered out?
My pleasure @phil21oo !
Use instead a -Row Splitter- node so that all the rows that were filtered out are available in a second table.
Do you need to split the content of filtered out rows into words before saving it in a CSV file?
thx for your quick help.
I have some words that always should be filtered out in a csv like (new york, la, …)
as a result i want the list without these words.
system
Closed
May 12, 2023, 9:14am
6
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.