Filter dataset with regular expression

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

fruit.yxmd

Workflow

Topic of Interest

Regex

Common Use Cases

Accepted answers

vizAlter

Hi @whiran — Try this solution:

REGEX_CountMatches([Fruit], "apple")

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

.*(apple).*

fruit__vA.yxmd

Qiu

@whiran

This one

All comments

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

Hi @whiran — Try this solution:

REGEX_CountMatches([Fruit], "apple")

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

.*(apple).*

fruit__vA.yxmd

whiran

@vizAlter @Qiu

Thanks both of you for the cooperation

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703