Find out which term was in the text

Hello,

I have a table of terms [aaa, bbb, ccc]
And a table with text [dddaaa, eeeccc, fffbbb, gggyyy]

I want a table with the text and the matching term - if any
dddaaa - aaa
eeeccc - ccc
fffbbb - bbb
gggyyy -

I did manage to test the occurrence of the term using the rule-based nodes, but I can´t tell which term was used for each row.

Thanks in advance!

Oi/Hi @sfafilho

One question – can one of your records be something like aaabbbccc?

Hi @sfafilho

Here is a simple example:

Cheers
Ana

2 Likes