- Function RegExpTest(patrn, strng)
- Dim regEx, Matches
- Set regEx = New RegExp
- regEx.Pattern = patrn
- regEx.IgnoreCase = True ‘为真则忽略大小写,否则严格匹配大小写
- regEx.Global = True
- Set Matches = regEx.Execute(strng)
- RegExpTest = Matches.count
- End Function
- MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))