Page History
...
| Code Block |
|---|
NewArray = SRP_Array("SortRows", Array, SortInfo, FormatOrientation, MajorDelim, MinorDelim, CaseSensitive) |
...
| Parameter | Description |
|---|---|
| Array | The dynamic array to be sorted. (REQUIRED) |
| SortInfo | An @FM delimited array listing the order columns are sorted and how they are to be sorted. (REQUIRED) |
| FormatOrientation | The given arrays formatorientation of array: LIST or ARRAY. (OPTIONAL) |
| MajorDelim | The delimiter that separates rows if Array is in LIST format or columns if it is in ARRAY format. (OPTIONAL) |
| MinorDelim | The delimiter that separates elements in within each column (ARRAY format) or row (LIST format). (OPTIONAL) |
| CaseSensitive | Determines if the sort is done case sensitively (set to 1, which is the default) or insensitively (set to 0). (OPTIONAL) |
...
- Most OI programmers are familiar with the LIST and ARRAY properties of the OI Edit Table. SortRows can sort using either formatorientation, whereas V119 requires your data to be in a LIST format.
- V119 requires specific delimiters. SortRows lets you specify your data’s delimiters.
- V119 often requires you to reorder your data since it always sorts starting at the first column. SortRows lets you specify the order in which columns are sorted.
...
- If you are sorting less than 4 megabytes of data, then use either format since the difference is negligible
- If you are sorting 4 megabytes of data or more, then do one of the following:
- If you have more rows in your data than columns, then use the LIST format if possible
- If you have more columns in your data than rows, then use the ARRAY format if possible
...
Orientation
The Format Orientation parameter tells the SortRows service what format the original array is in. If your 2-dimensional dynamic array is delimited by rows first, then set this parameter to "LIST". If your dynamic array is delimited by columns first, then set this parameter to "ARRAY". If omitted, "ARRAY" is assumed.
...
