Function String Searches Class

CountOverlappingMatches

Count the number of (possibly-overlapping) occurrences of the string vFind within vLine.

Signature (Visual Basic / VBA)

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

Code Example

    CountOverlappingMatches("122333444455555", "55") = 4

Parameters

Parameter Description
vLine The string which 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 occurrences anywhere within 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 if strings match. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.