regex works but how do i return the found string to a variable

[jove1776]

Maybe a simple question, so apologies in advance.

I have the following:

Code:

response ="blablahTO-001-A-01blahblablah"

Set oRegExp = New RegExp
oRegExp.IgnoreCase = True
oRegExp.Global=False
oRegExp.Pattern="([A-Z]{2})-([0-9]{3})-([A-Z]{1})-([0-9]{2})"

Msgbox oRegExp.Test(response)

I get a popup saying that it is found

i presume that the correct way to get the string is something like

Code:

string = oRegExp.Test(response)

this sets string to true, but i want string to be set to TO-001-A-01

but I don't know which function will return the found pattern?

Does anyone know how to assign the found pattern to the variable?

[jove1776]

Ok I managed to get it to work using the following I found on the net:

Code:

Dim re, testresults, showresults

Set re = new regexp
re.Pattern = "([A-Z]{2})-([0-9]{3})-([A-Z]{1})-([0-9]{2})"
re.Global = true
re.IgnoreCase = true

set testresults = re.Execute(response)
For each match in testresults
    showresults = showresults + match.value
Next

msgbox showresults

Unfortunately I didn't realize in the string i was searching there are 28 separate matches for that search which are all valid but all different.

I just need the very last instance of the match for my purposes.

Does anyone know what the regex is for this?

I am a bit new to regex

[jove1776]

I managed to solve the issue by using the string function right to cut down the string. I then used the regex to search for that pattern.

i bet you could do this with regex to match the last instance, please let me know if it is possible, as my code is a bit of a beginners messy code