Function Sort Orders Class

SortOrderMatchingCharacterPairs

Returns a string containing pairs of characters which have the same sort order within a specified collating sequence. Characters that have a unique position within the collating sequence (most non-alphabetic characters) are not included in the result string.

Signature (Visual Basic / VBA)

Public Function SortOrderMatchingCharacterPairs( _
    Optional ByVal vCompare As Variant _
    ) As String

Code Example

     SortOrderMatchingCharacterPairs(vbBinaryCompare) = ""
     SortOrderMatchingCharacterPairs(vbTextCompare) = "...AaBbCcDdEeFf..."

Parameters

Parameter Description
vCompare Specifies the sort order/collating sequence in which pairs characters matching characters are to be located. vCompare defaults to Binary comparisons if it is missing or Null or cannot be fixed up to a number; in the Binary collating sequence, no two characters match, so the function will return an empty string.

Notes & Version History

Note The results of example #2 has been condensed with "..." to save space.
Note Function currently only works for characters whose ASCII value is between 0 and 255, so it does NOT support UNICODE.