Use Reg Expression to check for 1 of 2 Patterns

[bdb1974]

Hi all,

Not sure why I'm having such a difficult time with this. But, I am not having any success
in getting the code to check each value and compare it against (2) patterns. If one of the
pattern matches, then continue.


If I'm checking for G as something like : geo-001.xls, Geo-003.xls or GEO-100.xls
Then the pattern should be something like : .Pattern = "(GEO-0)? |(GEO-1)?"
If I'm checking for G as something like: geo-200.xls, Geo-201.xls or GeO-203.xls
Then the patter should be something like :. Pattern = "Geo-2*"

Please Login or Register  to view this content.

Everything goes to NG

Any help is appreciated.

Thanks,

BDB

[Leith Ross]

Hello BDB,

Here is an example macro to reverse the first 3 characters in the pattern, if the first three characters are G,E, or O. Case is ignored.

Please Login or Register  to view this content.

[bdb1974]

Leith,

Thanks for the response, but you have confused me.
Why do I want or need to reverse the first 3 characters?
The Order of the first 3 characters are fine. I just need ignore the case of the first 3 Characters. I will also need to to be able to filter whether the numeral part of the string
begins with a 0,1 or 2 if it begins with a 0 or 1 then it should do "this".
If it starts with a 2 it should do something else.

HTMS,

BDB

[Leith Ross]

Hello BDB,

The in the code sample you posted it shows the order of first 3 being reversed. To check that the first 3 match "G","E", or "O" and not reverse them then use the macro below. The pattern checks that there are 3 digits following the hyphen.

Please Login or Register  to view this content.

[Leith Ross]

Hello BDB,

Sorry, I am working of code for a couple of projects. I rushed answering you. Here is the macro to check for the digits and act accordingly.

Please Login or Register  to view this content.

[bdb1974]

Leith,

Made a few minor changes to adapt better to my needs and it now works.

Thanks,

BDB