Function String Searches Class

CountStrings

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

Signature (Visual Basic / VBA)

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

Code Example

    CountStrings("122333444455555", "55") = 2
    CountStrings("1223334444", "NEW") = 0

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 non-overlapping appearances 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 find matching strings. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.