Signature (Visual Basic / VBA)
Public Function CharactersNotInString( _
ByVal vValue As Variant _
) As Variant
Code Example
CharactersNotInString("") = EveryCharacter
CharactersNotInString("ABBCCC") = Chr$(0) + ... + "@" + "D" + ... + Chr$(255)
CharactersNotInString("ABBCCC") = DifferenceCharacters(EveryCharacter, "ABBCCC") ' #3
Parameters
| Parameter | Description |
|---|---|
| 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. |
Notes & Version History
| Note | Similar to calling the DifferenceCharacters function with vStringOne set to EveryCharacter and vStringTwo set to vValue as in example #3. |
| 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. |