Row Filter

Dear Knime experts and enthusiasts! Need some help.

I have input of number in column

like
11123456789ZZ
21123456789AA
A2123456789WE

Now,
I want to filter the above number which includes first two digit an alphabet

thus row A2123456789WE would be removed.

Which node can I use?
there can be situation where both first two digit number is alphabet (AA, AB,RG,…etc) or one can also be as (A!, 2G, 9L,… etc)

So basically I want to remove such row which is having alphabet in first two digit…

hi there @ravi13,

seems this pattern ^.[a-zA-Z].*|^[a-zA-Z].* should work in Row Filter node with regular expression option checked.

Br,
Ivan

3 Likes

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