Matrix1 Utility Plug-ins

# SORT ARRAY RANGE

Syntax

SORT ARRAY RANGE Array(), Start, End SORT ARRAY RANGE Array(), Start, End, Field [, Field [, Field [, Field [, Field[, Field]]]]]

Description

The first form of this command can be used to sort non-UDT arrays into order. If used on a UDT array, an error will be triggered. The second form of this command can be used to sort UDT arrays into order. If used on a non-UDT array, an error will be triggered. Fields are specified numerically - 1 is the first field, etc. If you specify a field that is beyond the end of the format provided, an error will be triggered. It is not an error to specify a field of 0, but the field will be ignored. If the field is specified as a negative number, the field will be sorted in reverse sequence. When sorting strings, null strings and empty are arranged first (and are treated as equal), then by ASCII value of the string contents. When sorting an array with start and end positions specified, the start position must be lower than the end position, otherwise sorting will not take place.

Go back to ...

Matrix1Util_29 Commands Menu
Matrix1 Utils Main Index
Matrix1 Utils Command List
Commands Menu
Main Menu

Copyright © Ian Mold - Matrix1 Software 2006 - 2011