It is my first time to use patterns for capturing objects.
I cannot figure out what goes into the pattern in order to capture everything after "Details : Folders: ".
Example:
Cell value: Details : Folders: f1A795, f1B795, f2A795, f34955, fK683
Output: f1A795, f1B795, f2A795, f34955, fK683
My code below omits the first "f" and gives me this result: "1A795, f1B795, f2A795, f34955, fK683"
Set r = CreateObject("VBScript.RegExp")
r.IgnoreCase = True
r.Global = True
r.Pattern = "[\Details : Folders: ]+"
Can you help?
Bookmarks