How to extract text using regex in vb6

Question

Dim MyText As String

MyText = "anything [*]textToExtract[*] anything"

Result Should Be :

textToExtract

How are you using regular expressions in VB 6? You have to be using some kind of custom library, in which case you'll need to make sure that your code follows the syntax used by that library. — Cody Gray - on strike, Dec 23 '10 at 07:20
@Cody The reference the OP accepted in his previous question pointed him to use VBScript. — Dr. belisarius, Dec 23 '10 at 07:23
@Cody Gray: anyone who needs RegEx in VB6 uses the Microsoft Regular Expression parser which is part of any Windows systems younger than 10 years. — Doc Brown, Dec 23 '10 at 07:24

score 6 · Accepted Answer · answered Dec 23 '10 at 07:28

Sub test()
    Dim re As RegExp, m As MatchCollection
    Set re = New RegExp
    Dim MyText As String, extractedText As String
    MyText = "anything textToExtract anything"

    re.Pattern = "anything (.*) anything"
    Set m = re.Execute(MyText)
    extractedText = m(0).SubMatches(0)

End Sub

How to extract text using regex in vb6

1 Answers1