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
Solved! Go to Solution.
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
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...
No problem, happy to help 🙂
Regards,
Aidan
If you wouldn't mind taking a moment to mark the solution as 'accepted' it would be great 🙂
have a great day!
thanks.
Aidan