Contains in Filter

[vlad_kutateladze]

I need to filter text data by keyword.

For example, I need  "Demo", but in result I have also "Demographic" and all other word including "Demo" as part of the word, but i need only entire word "Demo"  

[Thableaus · Accepted solution]

Hi @vlad_kutateladze 

Use REGEX.

REGEX_Match ([Field], ".*\bDemo\b.*")

Cheers,

[Thableaus · Accepted solution]

By the way @vlad_kutateladze 

This REGEX means:

.* - any character 0 or more times

\b - word boundary (that means, everything that is not a word)

Demo - your keyword

\b - another word boundary (which means the word "Demo" will be isolated, not preceded or followed by any other word character)

.* any character 0 or more times

Word characters are any alphanumeric characters.

Cheers,

[vlad_kutateladze]

@Thableaus Thank you! Very helpful! 

[alkafalhas]

Hi @Thableaus 

What if I have a similar case, but this time i wanted to filter everything that contains "DEMO" including demographic as mentioned.

Stay safe, thank you in advance