Filter rows using list of words with wildcards

Hello @gonhaddock
hope this finds you well
isnt there a way to make filtering with wildcards based on the exact wording of the text.
I am using it for arabic text, and for example if it finds the letters “لكم” in longer word it flags as true while it shouldn’t

Continuing the discussion from Filter rows using list of words with wildcards:

Hello @mh_elhassan

This topic that you bring to the forum is very interesting; However, I don’t think I can help you with this, since I always work with the Latin alphabet.

Upgrading would require some research about alphabets from my side. Gather texts, testing…

Maybe some other colleagues in forum do have experience working this way. Let’s see.

@gonhaddock
even in English for example, if i put “er” it ll flag “emergency” as true because it contains “er”
I think if we change something in the regex matcher script inside the node it will be fixed.

1 Like

@mh_elhassan I did a few experiments and it seems you could try and use Regex Extraction to find exactly the phrase without it being embedded in a larger word. Please note I do not speak any Arabic myself.

regex_extract($["Arabic Phrase"], "\\bلكم\\b", 0, "i")

2 Likes

Now I see. Thanks for the extended explanation @mh_elhassan and the reporting of this issue. However this is the supposed behavior about what a wildcard does.

I will think about upgrading it with new functionality, allowing the user to select weather to rely or not on boundary spaces :thinking:

BR

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