Hi, I have the following information:
RowID | Description |
1 | Early Stage: Seed |
2 | Early Stage, Early Stage: Seed, Early Stage: Start-up |
3 | Early Stage, Early Stage: Seed, Early Stage: Start-up, Expansion / Late Stage, Venture (General) |
4 | Early Stage, Early Stage: Seed, Early Stage: Start-up |
5 | Early Stage, Growth |
6 | Early 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.
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.