Function String Searches Class

LeftOfFirstMatchFast

Return the portion of vLine before the first occurrence of vFind, else return vIfNotFound. If a match is found, it does not include the matching text in the string that is returned. Faster version of the LeftOfFirstMatch function which uses restrictive argument types to avoid argument fix-up code.

Signature (Visual Basic / VBA)

Public Function LeftOfFirstMatchFast( _
      ByRef vLine As String _
    , ByRef vFind As String _
    , ByRef vCompare As VbCompareMethod _
    , ByRef vIfNotFound As String _
    ) As String

Code Example

    LeftOfFirstMatchFast("This is a test.", "is", vbTextCompare, "") = "Th"
    LeftOfFirstMatchFast("This is a test.", "sample", vbTextCompare, "Not found.") = "Not found."

Parameters

Parameter Description
vLine The string which is to be searched from left-to-right for the appearance of string vFind.
vFind The string which is to be searched for within string vLine. Function returns an empty string if vFind is an empty string.
vCompare Specifies the type of comparison used to determine if strings match.
vIfNotFound The string which is to be returned if vFind does not appear within vLine.