community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Contains in Filter

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"  

Alteryx Certified Partner
Alteryx Certified Partner

Hi @Vlad_Kutateladze 

 

Use REGEX.

 

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

 

Cheers,

Alteryx Certified Partner
Alteryx Certified Partner

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,

@

Labels