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. |