Function String Searches Class

CountLeadingStrings

Count the number of occurrences of one string at the beginning of another.

Signature (Visual Basic / VBA)

Public Function CountLeadingStrings( _
      ByVal vLine As Variant _
    , ByVal vFind As Variant _
    , Optional ByVal vCompare As Variant _
    ) As Variant

Code Example

    CountLeadingStrings("AAA---AA", "A") = 3

Parameters

Parameter Description
vLine The string whose beginning portion is to be searched. Function returns Null if vLine is Null or cannot be fixed up to a String.
vFind The string whose number of non-overlapping occurrences at the beginning of vLine is to be counted. Function returns Null if vFind is Null or cannot be fixed up to a String. Function returns 0 (zero) if vFind is an empty string.
vCompare Specifies the type of comparison used to determine is strings match. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.