Selection of case using specific rule

[ravi13]

Hello!! Knime Experts & Enthuse.

Hope you are doing well.

Just want your help in creating workflow next step.

Requirement -

Select Cases from Key Relative Number where following condition is meet:
Must have first 2 digit numeric, next 5 digit alphabetic, next 4 digit numeric and last digit alphabetic.

Input:

Key Relative Number
654AAAA1234Q
01AAAAA1234A
0AABCD12345Q
23QWERT7894Y
1234AAAQ4561

Output-

Key Relative Number
01AAAAA1234A
23QWERT7894Y

Which node I can use and its command.

Thanks in advance!!

[armingrudd]

Hi @ravi13,

The Row Filter node and this regex is what you are looking for:

\d{2}[a-z]{5}\d{4}[a-z]

Select the “Key Relative Number” column and check the “regular expression” option.

[ravi13]

Thanks @armingrudd

But row filter ?

Sorry I got it.

[armingrudd]

If you want to keep the rows where the pattern matches the value.
Do you need something else?