Character Sort Functions

Alpha Five provides the following Character functions.

Function

 

Description

KEYWORDS()

V5

Returns a sorted list of all of the unique words in Character_Expression. Case-sensitive.

KEYWORDSI()

V5

Returns a sorted list of all of the unique words in Character_Expression. Case-insensitive.

KEYWORDSX()

V5

Returns a sorted list of the Soundex values of all of the unique words in Character_Expression.

Line_ReverseOrder()

V6

Reverses the order of a CR-LF delimited list.

SORTSTRING_BY_LENGTH()

V6

Sorts a CR-LF delimited list by the length of its entries.

SORTSUBSTR()

V5

Sorts a delimited string of values and returns the result. Some features are only supported by version 6.

See Also

Character Functions