REGEX help please

[NatSnook]

Hi regex gurus 🙂

i have a large set of filenames which contain an identifier in various positions of the filename. the identifier is two characters which are always the same followed by 5 digits that vary eg 

this is the filename for AB12345.pdf

AB54321 details here.docx

also AB32145 info here.pdf

is there a way of parsing this in regex to extract the 7character identifiers?

TIA

Nat

[KarolinaRoza · Accepted solution]

hi @NatSnook 

please try Regex with formula:

(\w{2}\d{5})

regards,

Karolina

[NatSnook]

perfect thank you - silly i couldn't work that one out 🙄