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
Solved! Go to Solution.
@whiran — Try this solution:
REGEX_CountMatches([Fruit], "Apple", 1)
And, using RegEx:
Refer to attached the solution for more understanding:
@whiran
if you want case sensitive match, try below.
@Qiu Yes.
@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:
@whiran
By default, it will do case-insensitive match, unless you trun on the -i switch.
Thanks for the mark.