Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Filter dataset with regular expression

whiran
8 - Asteroid

I have attached a text input with my workflow. Can some one guide me on  how to filter rows having  only apple/apples from the column with RegEx tool

14 REPLIES 14
Qiu
20 - Arcturus
20 - Arcturus

@whiran 

How about this one?

Appeciate you would mark it as accepted if you think it is useful.

 

Capture112.PNG

whiran
8 - Asteroid

@Qiu Can you do it with regex tool in Alteryx designer if you don't mind

vizAlter
12 - Quasar

Hi @whiran — Try this solution:

REGEX_CountMatches([Fruit], "apple")

vizAlter_0-1603937249560.png

 

 

And, using a RegEx tool with Match output method, like below:

.*(apple).*

vizAlter_1-1603937478478.png

 

Qiu
20 - Arcturus
20 - Arcturus

@whiran 

This oneCapture113.PNG

whiran
8 - Asteroid

@vizAlter @Qiu 

 

Thanks both of you for the cooperation

Qiu
20 - Arcturus
20 - Arcturus

@whiran 

Thank you for the mark also.

vizAlter
12 - Quasar

@whiran — Thank you! 🙂

whiran
8 - Asteroid

@vizAlter @Qiu 

Can you all amend the  solution to accept apples or apples though it contain with capital letters as well (ex: Apples / Apple or apple/apples) 

Qiu
20 - Arcturus
20 - Arcturus

@whiran 

You want Apples / Apple to be set as match as well?

Labels