I want to use regular expressions to retrieve the position of a match

[myspiral]

I want to use regular expressions to retrieve the position of a match. For example In the phrase "Help me please" I want to retrieve the position of "me" any suggestions

 

[DotNetGnat]

try this:

InStr("Help me please","me")

-DNG

 

[myspiral]

i would rather use regex to find the position.

 

[tsdragon]

Use the firstIndex property of the Match object. The following example is from MSDN:

Function RegExpTest(patrn, strng)
   Dim regEx, Match, Matches   ' Create variable.
   Set regEx = New RegExp   ' Create regular expression.
   regEx.Pattern = patrn   ' Set pattern.
   regEx.IgnoreCase = True   ' Set case insensitivity.
   regEx.Global = True   ' Set global applicability.
   Set Matches = regEx.Execute(strng)   ' Execute search.
   For Each Match in Matches   ' Iterate Matches collection.
      RetStr = RetStr & "Match " & I & " found at position "
      RetStr = RetStr & Match.FirstIndex & ". Match Value is "'
      RetStr = RetStr & Match.Value & "'." & vbCRLF
   Next
   RegExpTest = RetStr
End Function
MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))

Tracy Dryden

Meddle not in the affairs of dragons,
For you are crunchy, and good with mustard.