Filtering Help

Question

Hi, I have the following information:

RowIDDescription1Early Stage: Seed2Early Stage, Early Stage: Seed, Early Stage: Start-up3Early Stage, Early Stage: Seed, Early Stage: Start-up, Expansion / Late Stage, Venture (General)4Early Stage, Early Stage: Seed, Early Stage: Start-up5Early Stage, Growth6Early Stage, Early Stage: Start-up

The data format is as the above and I want to filter out those that have only "Early Stage: Seed" / "Early Stage: Start-up" / "Early Stage"

How do I set the filter so it will return only row 3, and row 5?

Please help. Thank you.

Deano478 · Answer

Hey @dhakim1996 if you just want to use the Filter tool you could set it up like this:

Christina_H · Answer

Here's an alternative without RegEx

Filter for non-matches.yxmd

Martyn · Answer

Filter tool with the following should work.

REGEX_CountMatches([Description],"(Early Stage\: Seed|Early Stage\: Start-up|Early Stage)") < REGEX_CountMatches([Description],"\,") + 1

First part counts how many times any of the listed strings is present and the second part counts how many delimiters there are (and adds 1 for the number of items there are). As long as the first part is lower than the second, then there must be an item in the string that is not in your list.