RegEx for filtering out columns that do not contain letter H

[45179902]

I have a table of data looks something like this:

1	6	Happy         H	KEEP
2	7	H  H. WORLD	KEEP
3	8	HAPPY	KEEP
4	9	HENRY	REMOVE
5	0	CENTRE H.	KEEP

I want to keep all the rows with KEEP and without H (uppercase).

3	8	HAPPY	KEEP
5	0	CENTRE H.	KEEP

[atcodedog05 · Accepted solution]

Hi @45179902 

Here is how you can do it.

Workflow:

Hope this helps : )

[45179902]

Hi @atcodedog05, thank you for the response! You've been helpful like always. I guess I haven't fully understood how contains() works. What does the 0 mean in your !contains() formula?

[atcodedog05]

Hi @45179902 

0 is an optional config. Which means make it case sensitive take only upper H and not lower h.

Hope this helps : )

[atcodedog05]

Happy to help : ) @45179902 

Cheers and have a nice day!