Quote:
Originally Posted by ayomama
Now, what is the pattern to fully match @PART_01 and @ERTDRETHH ?
In other words, I'm looking for the syntax to make the last 3 characters "_01" optional. The 3rd character from last (if present) is always an underscore and the next 2 are numbers.
|
You could use a wildcard Find expression like:
strSearch = "\@[A-Z]{2}[A-Z_0-9]{1,}"
but you may get false matches