Public Function CharactersNotInString( _
ByVal vValue As Variant _
) As Variant CharactersNotInString("") = EveryCharacter
CharactersNotInString("ABBCCC") = Chr$(0) + ... + "@" + "D" + ... + Chr$(255)
CharactersNotInString("ABBCCC") = DifferenceCharacters(EveryCharacter, "ABBCCC") ' #3See also: DifferenceCharacters Function
EveryCharacter PropertyNote: Similar to calling the DifferenceCharacters function with vStringOne set to EveryCharacter and vStringTwo set to vValue as in example #3. vValue: The string containing the characters that are to be excluded from the result string. Function returns Null if vValue is Null or cannot be fixed up to a String.
Note: Function uses the ASCII value of characters to determine if they match, which is in effect the same as using Binary comparisons.
Note: The characters in the result string are always returned in order by their ASCII value.
Copyright 1996-1999 Entisoft
Entisoft Tools is a trademark of Entisoft.