Public Function FirstMatchingPosition( _
ByVal vOne As Variant _
, ByVal vTwo As Variant _
, Optional ByVal vCompare As Variant _
) As Variant FirstMatchingPosition("AAABBBCCC", "CBAABCCBA") = 3
FirstMatchingPosition("AAABBBCCC", "BBBCCC") = 0See also: FirstNonMatchingPosition Function
DifferenceString Function
CompareStrings FunctionvOne: One of the two strings from which characters in corresponding positions will be compared for a match. Function returns Null if vOne is Null or cannot be fixed up to a String. vTwo: One of the two strings from which characters in corresponding positions will be compared for a match. Function returns Null if vTwo is Null or cannot be fixed up to a String.
vCompare: Specifies the type of comparison used to determine if corresponding characters match. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.
Function returns 0 (zero) if no corresponding characters match.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.