or in regular expressions

[Mai_Nashaat]

Hi guys

I want to filter rows in a string column with values “ZRE5” or “S1”… how can I do that?

[Thyme]

You can put this in a Rule-based Row Filter:

$yourStringColumn$ = "ZRE5" OR $yourStringColumn$ = "S1" => TRUE

Use “include TRUE matches” if you want to keep those rows, or “include FALSE matches” if you want to exclude them.

The Rule-based Row Filter also works with Wildcards, but then you need the LIKE operator and also RegEx (MATCHES operator):

$yourStringColumn$ LIKE "ZRE5*" OR $yourStringColumn$ MATCHES "S1.*" => TRUE

[gonhaddock]

Hello @Mai_Nashaat

If looking for exact match:
Row Filter node (regular expression check mark):
ZRE5|S1

If looking for wildcards:
(?i)(.*?(ZRE5|S1)[^$]*)$

BR