Application icon

Sort Form

This function is used to set or remove sort formatting from one or more fields or a named variable.

The supplied text fields may contain any of the escape sequences described in Escape Sequences.

This function utilizes the Rename Exception Natural Sort Set. The set contains a list of words to be moved from the front of a field. Typically the words are The, A and An.

The function will always treat the Multi Value Delimiter as a field separator. If you have more than one value in a field, they will be processed correctly.

Optionally, you can also specify an additional sub-field separator. For example ' & '.

Example: Set for sorting using delimiter ' & ':

Bob Dylan & The Band   -->  Bob Dylan & Band, The

Example: Set for non sorting using delimiter ' & ':

Bob Dylan & Band, The   -->  Bob Dylan & The Band