vba regular expression - 18May2021 what will be pattern

[Mallesh23]

Hi Team,

Please suggest Regular expression.


xxxxxxxxxx 18May2021 zzzzzzzz First two Integer, 3 letter strings , Year 4 digit.
yyyyyyyyyy 05JUN2021 zzzzzzzz

my attempt like this [d[0-9]{2}\ d[A-Z]{3}\D[0-9]{2}


Thanks
mg

 

[Marc L]

Hi,​

​

as no needs RegExp here with VBA basics text functions …​

 

[Mallesh23]

Hi Starc,

Just for learning purpose, is my above expression correct.
or suggest what will be the pattern.


Thanks
mg

 

[Marc L]

​

As I can't see any benefit to maybe slow down your VBA procedure with RegExp instead of an easy direct VBA basics text function …​

 

[Mallesh23]

Hi Mark,

Thanks for your help.


Thanks
mg