Use VBA Regex to find mulitple matches between two same key words
Say if I have a text that is segemented into sets by keywords
And I want to find the matches between the keyword set.
For example, a complex string like: “gfdgfsdhfs Set 415468498 Set
65576dsadas&^$# Set“
I want to find the matches between those sets into
gfdgfsdhfs Set
415468498 Set
65576dsadas&^$# Set
I know I can use left function to write into a string array,
but I am just curious if there is regex expression to be executed into match collection.
The test site I am using is regex101.com/
I have tried this method Set.*Set
but all I get is one match from the first Set to the last Set
Read more here: Source link
