Public Function CountLeadingStrings( _ ByVal vLine As Variant _ , ByVal vFind As Variant _ , Optional ByVal vCompare As Variant _ ) As Variant
CountLeadingStrings("AAA---AA", "A") = 3See also:
CountTrailingStrings Function CountStrings FunctionvLine: 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.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.