Function Character Arrays Class

UniqueCharacters

Quashes all repeated runs of a character to a single character.

Signature (Visual Basic / VBA)

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

Code Example

    UniqueCharacters("CCCBBABBCCC") = "CBABC"
    UniqueCharacters("122333122333") = "123123"

Parameters

Parameter Description
vValue String from which repeated runs of the same character will be replaced by a single copy of the character. 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.