Public Function LastMatchingCharacter( _ ByVal vStartPos As Variant _ , ByVal vLine As Variant _ , ByVal vFindChars As Variant _ , Optional ByVal vCompare As Variant _ ) As Variant
LastMatchingCharacter(Null, "4455CBA", "12BC") = "B" LastMatchingCharacter(Null, "4455CBA", "FGHIJ") = ""See also:
LastNonMatchingCharacter Function FirstMatchingCharacter Function InStrCharactersReverse FunctionLike the InStrCharactersReverse function except that it returns the character itself instead of the position of the last match.
vLine: The string which is to be searched from right-to-left for characters that appear in string vFindChars. Function returns Null if vLine is Null or cannot be fixed up to a String.
vFindChars: String containing characters that are to be searched for within string vLine. Function returns Null if vFindChars is Null or cannot be fixed up to a String.
vStartPos: The character position in string vLine where the search is to begin. vStartPos defaults to the position of the last character in the string vLine (the length of the line) if it is Null or cannot be fixed up to a number.
vCompare: Specifies the type of comparison used to find matching characters present in both strings. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number.
Function returns an empty string if none of the characters in string vFindChars appear within string vLine.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.