Function String Searches Class

LastNonMatchingCharacter

Returns the first character within string vLine that does not match any of the characters within string vFindChars.

Signature (Visual Basic / VBA)

Public Function LastNonMatchingCharacter( _
      ByVal vStartPos As Variant _
    , ByVal vLine As Variant _
    , ByVal vFindChars As Variant _
    , Optional ByVal vCompare As Variant _
    ) As Variant

Code Example

    LastNonMatchingCharacter(Null, "4455CBA", "45DEF") = "A"
    LastNonMatchingCharacter(Null, "4455CBA", "45ABCDEF") = ""

Parameters

Parameter Description
vLine The string which is to be searched from right-to-left for characters that do not appear in string vFindChars. Function returns Null if vLine is Null or cannot be fixed up to a String.
vFindChars String containing characters whose appearance within string vLine is to be ignored. 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 determine if characters match. 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 all of the characters within vLine also appear within vFindChars.

Notes & Version History

Details Like the InStrNotCharactersReverse function except that it returns the character itself instead of the position of the last non-match.