Search words from a list in a sentence and add the words found to a new column

[Asghar]

The attached image has the example of the Input data and how the Output data to be reflected.
I used Rule Engine (Dictionary) to add a single word, but not sure how to do it for multiple words.

If there is an existing post for this topic, please do tag it. I did not find a similar post, hence created this.

[Daniel_Weikert]

Try dictionary tagger for this
br

[Asghar]

It did not work for this data set.

[gonhaddock]

Hello @Asghar

@Asghar

If there is an existing post for this topic, please do tag it. I did not find a similar post, hence created this.

Take a look into this post:

Search 1 word in a cell with multiple words

Hello Everyone, I have one excel file with a list of allowed words to be checked in the second. they both have an ID column to make the match. here an example: file1: ID Words1 231 tree 432 apple 511 mug 434 cat File 2: ID Words2 231 tree, bee 432 car 511 mug, cherry, nut 434 dog I want to highlight for the same ID all cells of file2 where words2 are not contained in words1 in file1. In the case of mul…

I think that you can get insights from it. Duplicating the column $wildcard$ in the loop and using it for the pivoting, it can do the trick.

BR

[gonhaddock]

Hi again @Asghar

P.S.- If $words_found$ order (text position?) is important, some additional work would be needed; sorting based on indexOf() can be added in the loop as well.

BR

[Add94]

Hi @Asghar

Please see the workflow attached. I believe it’s easiest to do with regex-based nodes & loops. Examples below using either palladian’s regex extractor (available on nodepit) or Column expressions:

Wildcard search.knwf (36.3 KB)

hope this helps!
Adam

[Asghar]

HI @Add94 - thanks for the workflow

The Regex Extractor does the job.

Facing performance issues when using Column expressions.

[Asghar]

Hi @gonhaddock - Thank you for tagging the post.

And, No - the text position doesn’t matter.