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. |