<-- Previous || Up || Next -->

Count Overlapping Matches Function
String Searches Class

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

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

Example:
    CountOverlappingMatches("122333444455555", "55") = 4
See also:
    CountStrings Function
    CountCharacters Function
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.

Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.