Struggling w. RegEx

[korodidanielp]

Hi All,

I am looking for some help with RegEx. Although it doesn't look too complicated I'm unable to make it match my example.

C17CBDB002

.*([a-z]\d{2}[a-z]{4}\d{3}).*

Could any of you advise what am I doing wrong?

Thanks in advance,

Daniel

[Aidan_K]

Hi @korodidanielp 

There are a few ways to achive what you need.

Using the regex tool to parse field1, here are two examples -

([a-z])(\d{2})([a-z]{4})(\d{3})

or 

([a-z])(\d\d)([a-z]*)(\d\d\d)

regards,

Aidan

[korodidanielp]

Thank you very much!

I just realized that the problem with my configuration was that I left the "Case Insensitive" checkbox unticked... Usually it is "Case Sensitive" option everywhere in every software, so I didn't even read the caption carefully because I wouldn't assume a "case INsensitive" option to exist... Kinda counter-intuitive...

[Aidan_K]

No problem, happy to help 🙂

Regards,

Aidan

[Aidan_K · Accepted solution]

If you wouldn't mind taking a moment to mark the solution as 'accepted' it would be great 🙂

have a great day!

thanks.

Aidan