Public Function InStrNotCharacters( _
ByVal vStartPos As Variant _
, ByVal vLine As Variant _
, ByVal vFindChars As Variant _
, Optional ByVal vCompare As Variant _
) As Variant InStrNotCharacters(1, "321CBACBA", "123") = 4
InStrNotCharacters(4, "321CBACBA", "ABC") = 0See also: FirstNonMatchingCharacter Function
InStrCharacters Function
InStrNotCharactersReverse FunctionvStartPos: 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.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.