Filter dataset with regular expression

[whiran]

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

[Qiu]

@whiran 

How about this one?

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

[whiran]

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

[vizAlter · Accepted solution]

Hi @whiran — Try this solution:

REGEX_CountMatches([Fruit], "apple")

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

.*(apple).*

[Qiu · Accepted solution]

@whiran 

This one

[whiran]

@vizAlter @Qiu 

Thanks both of you for the cooperation

[Qiu]

@whiran 

Thank you for the mark also.

[vizAlter]

@whiran — Thank you! 🙂

[whiran]

@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]

@whiran 

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