6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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
17 - Castor

@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
17 - Castor

@whiran 

This oneCapture113.PNG

whiran
8 - Asteroid

@vizAlter @Qiu 

 

Thanks both of you for the cooperation

Qiu
17 - Castor

@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
17 - Castor

@whiran 

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

Labels