Rule-Based row filter LIKE or IN?

[fostc80857]

Hi

I have a list of invoices that I would like to filter based on whether the invoice number contains certain values. A example list of invoices is provided below:

21174 WT015/0134-3.2 10
21173 MG022/0208-2.3.3 1
PRIV00003353 OPEX2-4.175 11
CONTPR20420 ST022/0105-4.41 1
10 NW1562-05C 10
Jan 2022 Service Invoices

I would like to remove the invoices that contain the following:

WT0
MG0
OPEX
ST0

The result of the filter should leave me with the bottom two invoices only. I have tried using the LIKE (with wildcard) and IN function in the rule-based row filter node but it keeps returning a blank table. Where am I going wrong?

Thanks
Chris

[marzukim]

excluded true rules:
$column1$ LIKE “WT0” => TRUE
$column1$ LIKE “MG0” => TRUE
$column1$ LIKE “OPEX” => TRUE
$column1$ LIKE “ST0” => TRUE

[fostc80857]

Hi @marzukim

I have used the following and it doesn’t remove any of the OPEX invoices (when I exclude true rules)

$INVOICE_NUM$ LIKE “OPEX” => TRUE

[marzukim]

hi fostc80857
not sure why the wildcard asterisk is missing from my previous typo.
i’m attaching an image for easy reference.

rgds