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

[vizAlter]

@whiran — Try this solution:

REGEX_CountMatches([Fruit], "Apple", 1)

 And, using RegEx:

Refer to attached the solution for more understanding:

[Qiu]

@whiran 
if you want case sensitive match, try below.

[whiran]

@Qiu Yes.

[vizAlter]

@whiran — And use the expression below in a RegEx tool if you just want to keep the rows which have only apple/apples/Apple/Apples:

^([Aa]pple|[Aa]pples)$

or

^(apple|apples|Apple|Apples)$

And, make sure "Case Insensitive" option is unchecked.

Refer to updated the attached workflow:

[Qiu]

@whiran 
By default, it will do case-insensitive match, unless you trun on the -i switch.

Thanks for the mark.