AlphaSort Command

Use the AlphaSort command in a Logic Template to sort results in either ascending or descending order, using a field containing string data. Strings are compared on a character by character basis. Before comparison, strings are converted to lower case. Strings beginning with "the" are modified to remove the leading "the" and spaces following it prior to sorting.

To execute a Alphabetical Sort request, use the AlphaSort command with three arguments:

AlphaSort( rev, fld, pas );

AlphaSort Arguments

Argument

Description

rev

Indicates whether results will be sorted in alphabetical or reverse alphabetical order.

fld

The string data field on which to sort.

pas

The pass during which the sort is to be executed.

Access the AlphaSort Dialog Box by selecting the Alpha menu item under the Sorting category of the Logic Template editor command menu.

Examples

Command

Description

AlphaSort( ASCENDING, Title, 1);

Sort results alphabetically by data field "Title" during pass 1.

AlphaSort( DESCENDING, Title, 4);

Sort results in reverse alphabetical order by data field "Title" during pass 4.