Updated: March 2009
Returns the position in a search string where a match occurs.
The FirstIndex property uses a zero-based offset from the beginning of the search string. In other words, the first character in the string is identified as character zero (0). The following code illustrates the use of the FirstIndex property.
Function RegExpTest(patrn, strng) Dim regEx, Match, Matches, s ' Create the regular expression. Set regEx = New RegExp regEx.Pattern = patrn regEx.IgnoreCase = True regEx.Global = True ' Do the search. Set Matches = regEx.Execute(strng) ' Iterate through the Matches collection. s = "" For Each Match in Matches s = s & "Match found at position " s = s & Match.FirstIndex & ". " s = s & "Match Value is '" s = s & Match.Value & "'." s = s & vbCRLF Next RegExpTest = s End Function MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))