Regex with a common pattern

[sergiobar93]

Dear Knime Community

I’ve be struggling with partial string matching in Knime. Basically the task is to extract all records that follow this pattern: AAA111 (where A means any letter and 1 means any number its always 3 letters followed by 3 numbers)

Does anybody have any ideas how to resolve this? or experience working with partial matching in Knime?

Thank you in advance!

[Daniel_Weikert]

You need a regex pattern right? [A-Z]{3}\d{3}

[sergiobar93]

Yes, I need the pattern and also to extract it, already used the node String manipulation and used this function

regexMatcher($Texto$,".[a-zA-Z]+[a-zA-Z]+[a-zA-Z]+[0-9]+[0-9]+[0-9].")

but just got true or false, I need to extract what it found.

Example: sale-aaa111 today
It should extract aaa111

[Daniel_Weikert]

This is because you use the regexMatcher. Try using the regexsplit or regexextractor node

[ipazin]

Hello @sergiobar93,

this one should work in Regex Split node:
.*([A-Za-z]{3}\d{3}).*

Welcome to KNIME Community!

Br,
Ivan

[sergiobar93]

Hi It worked with regex extract using this '*[a-zA-Z]{3}\d{3}'*

Thank you