Problems working with .Pattern formula and Regular Expressions

Hello,

I apologize as I am trying to minimize turning to the forum for basic problems. In trying to properly adjust the code, I have run into an issue regarding the .Pattern line of VBA code.

Here is the excellent code that was given to me:

Please Login or Register  to view this content.

When I apply the code to the data (see attachment), this is the result and what I need:
Desired Results.jpg

However, I tried to adjust the .Pattern formula to parse the other data from the same document. I attempted this by replacing:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

The result I get is:
Store Promotions Parse Attempt.jpg

I also tried replacing:

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

The result I get is:
Online Day Stages Parse Attempt.jpg

I'm very new to VBA code and I think that my mistake is in understanding how Regular Expressions work. Would it be possible for someone to correct my two attempts (as seen above) at changing the .Pattern formula? Also, if it is convenient, could it be briefly explained why my adjustments do not work with the current Regular Expression?

Thank you so much for your time and I look forward to any assistance offered.

Hi phoenixjasper,
try to change this line

Please Login or Register  to view this content.

and this line

Please Login or Register  to view this content.

A quick point..

I apologize as I am trying to minimize turning to the forum for basic problems

I certainly wouldn't call trying to get help with Scripting Dictionary, Regex and ArrayList anything closely resembling a basic problem...

Somewhere to test Regex patterns:

http://www.regexr.com/

and

https://regex101.com/

Re PM
Would you be able to arrange the code as you want?
Patterns are there in myPtns.

Please Login or Register  to view this content.

Originally Posted by nilem

Hi phoenixjasper,
try to change this line

Please Login or Register  to view this content.

and this line

Please Login or Register  to view this content.

Thanks so much for the quick response, nilem! I did try that code and it worked great. This was also a parse that I needed but did not make it that far after my first two attempts did not work. I should be able to include your line of code along with the others from above.

Originally Posted by apo

A quick point..



I certainly wouldn't call trying to get help with Scripting Dictionary, Regex and ArrayList anything closely resembling a basic problem...

Somewhere to test Regex patterns:

http://www.regexr.com/

and

https://regex101.com/

Thanks a ton for the response, as well! I will use some of my weekend to get a better feel for the Regex patterns from both sites. Glancing over it, it looks like a great resource.