Filter letters and numbers using Knime

[ann_knime]

Hi,
I am new to Knime. Just wanted to ask for help on how I can filter a combination of letters and numbers using the Column Expressions node. Here is an example of the items I need to filter:

C1726UBB
C1778UBB
C4602UBC
C4603UBC
MST2036F
These items can start with any letter and may contain different combinations of letters and numbers.

Hope somebody can help me.

Thanks!

[ipazin]

Hello @ann_knime,

and welcome to KNIME Community!

With Column Expressions you can not filter data. For filtering there are Row Filter, Rule-based Row Filter and other specific row filter nodes but these 2 mentioned you can probably use in this case. They have functionality to filter based on regular expressions and that is most likely what you should use but it’s hard to say as you only shared output data set. Share input as well and logic behind it if not obvious.

There is also possibility you need to extract this from text. In this case you should also use regular expressions but again data and more context is needed

Br,
Ivan

[ann_knime]

Hi ipazin,

Thank you for your response. I was able to use the String manipulation node in filtering the format of a combination of letters and numbers. Thanks for your help!