vba regex only returns first match

Question

my regex match in VBA (WORD) only gives one result.

I created this function

Function RE6(strData As String) As String

    Dim RE As Object, REMatches As Object
    Set RE = CreateObject("vbscript.regexp")
    With RE
        .MultiLine = False
        .Global = False
        .IgnoreCase = True
        .Pattern = "\[substep [a-zA-Z]\](.*?); {1}"
    End With

    Set REMatches = RE.Execute(strData)

    RE6 = ""


End Function

The problem here is that it only gives the first result. For example I got a string:

[step 1] title for substeps;  [substep a] step a; [substep b] step b; [substep c] step c;

My result is:

[substep a] step a;

only 1 match, not the step b and c.

marg · Accepted Answer · 2012-09-06 13:29:35Z

13

You need to set Global to True

http://msdn.microsoft.com/en-us/library/tdte5kwf%28v=vs.84%29

answered Sep 6, 2012 at 13:29

marg

2,8251 gold badge31 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Vince V. Over a year ago

oh my god is it that simple.. Thanks!

Collectives™ on Stack Overflow

vba regex only returns first match

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related