Function String Searches Class

InStrNotCharacters

"In String Not Characters" Return the position of the first character in vLine that is NOT in vFindChars.

Signature (Visual Basic / VBA)

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

Code Example

    InStrNotCharacters(1, "321CBACBA", "123") = 4
    InStrNotCharacters(4, "321CBACBA", "ABC") = 0

Parameters

Parameter Description
vStartPos The character position in string vLine where the search is to begin. vStartPos defaults to 1 (one) if it is Null or cannot be fixed up to a number.
vLine The string which is to be searched from left-to-right 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.
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 0 (zero) if all of the characters within vLine also appear within vFindChars.