How do I retrieve a string that matches the regular expression of a VBA without postreading?

I have a question about regular expressions in vba. I looked it up on vba and found that it doesn't read afterwards.
[~~~]
Could you tell me how to avoid reading after matching only the characters in parentheses?

regular-expression vba

2022-09-30 14:26

1 Answers

SubMatches can be taken out by grouping using parentheses such as (.*?).

Sub button 1_Click()
    Dimre As RegExp
    Set = New RegExp
    re.Pattern="[(.*?)]" 
    Set matches=re.Execute("hoge[fuga]piyo")
    MsgBox matches.Item(0).SubMatches(0)'"fuga" appears.
End Sub

References

Use regular expressions in VBA (RegExp object method)

2022-09-30 14:26

If you have any answers or tips

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656