REGEX TO FILTER MULTIPLE STRINGS IN A FIELD

Hello -

I am attempting to use RegEx to filter 4 specific strings from a field in my data. The field is string, and the unique values are 11, 12, 13, 21, 22, 23, 31, 32, 33. I am trying to filter out all rows that have 11, 12, 21, or 22. I have not used RegEx for this before, any points on how I can accomplish this?

Thank you for your time, and I hope you all are well!!

Use Rule-based Roe Filter with expression like the one
$REQUEST$ MATCHES “.+(11|12|21|22).+” => TRUE

2 Likes

Hi @MapperKnime,

Why not using the Nominal Value Row Filter node?

:blush:

4 Likes

Example.knwf (5.9 KB)
Hi MapperKnime,

you can do it either by the rowfilter regex option
(11|12|21|22){1}
or maybe a reference row filter would be easier

I added both to the attached example workflow :slight_smile:

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.