Function Character Arrays Class

UsedCharacters

Return a string containing the uniquely-occurring characters within a string. Characters are returned in the order in which they appear in string vValue; they are NOT returned in sorted order.

Signature (Visual Basic / VBA)

Public Function UsedCharacters( _
    ByVal vValue As Variant _
    ) As Variant

Code Example

    UsedCharacters("ABBCCC123ABCD") = "ABC123"
    UsedCharacters("CCCBBBAAABBBCCC") = "CBA"

Parameters

Parameter Description
vValue String containing the characters of which the unique ones will be copied to the result string the first time that appear within string vValue. Function returns Null if vValue is Null or cannot be fixed up to a String.

Notes & Version History

Note Function uses the ASCII value of characters to determine if they match, which is in effect the same as using Binary comparisons.
Note Function currently only works for characters whose ASCII value is between 0 and 255, so it does NOT support UNICODE.