Hello everyone
As starting point, I am seeking for this approach of using regex so please don't post any other approaches as I am already have different working alternatives but my target is to learn this specific point (which is to extract the groups within the regex pattern)
To make everything is clear, here's HTML page on the following link
https://pastebin.com/nu0dLvch
Copy the contents and paste into text file and save as Sample.html on the drive C:\
And use selenium in VBA to run the following code
The code opens the Sample.html and with a pattern extracts block of data .. Then I used SPLIT function to split the five parts of each block ..
The code works fine and the results as expected exactly
What I am seeking to learn a new skill which is to group the five parts using the pattern itself then extract the five parts(groups) to a row and so on
With the help of experts at regex, I got the following pattern that do the task of grouping
https://regex101.com/r/AUBup2/2
And this is the pattern
What I need to learn (TO LEARN) >> to learn how to extract the groups from a pattern ..
Here's snapshot of the final output
Untitled.png
Thanks advanced for help
** Posted here too
http://www.eileenslounge.com/viewtopic.php?f=30&t=34784
Bookmarks