Page History
...
| Code Block |
|---|
NewArray = SRP_Sort_Array(Array, SortInfo, IsList, MajorDelim, MinorDelim, CaseSensitive) |
Returns
The sorted array.
...
| 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. See Remarks for details. |
| IsList | Setting this to 1 Indicates that the Array parameter is in LIST format. Setting it to 0 indicates that it is in ARRAY format. Optional. If you omit this parameter, 0 (ARRAY format) will be assumed. |
| MajorDelim | The delimiter that separates rows if Array is in LIST format or columns if it is in ARRAY format. Optional. If you omit this parameter, @FM will be assumed. |
| MinorDelim | The delimiter that separates elements in within each column (ARRAY format) or row (LIST format). Optional. If you omit this parameter, @VM will be assumed. |
| CaseSensitive | Determines if the sort is done case sensitively (1) or insensitively (0). Optional. If you omit this parameter, the sort will be case sensitive. |
Remarks
OpenInsight provides sorting capabilities via it's V119 routine, and it is quite sufficient for the task. However, it can be cumbersome to prep your data to meet its strict requirements. SRP_Sort_Array is much easier to use in three waysgives you standardized sorting and ease of use:
- Most OI programmers are familiar with the LIST and ARRAY properties of the OI Edit Table.
...
- SRP_Sort_Array can sort using either format, whereas V119 requires your data to be in a LIST format.
- V119 requires specific delimiters. SRP_Sort_Array lets you specify your data’s delimiters.
- V119 often requires you to reorder your data since it always sorts starting at the first column. SRP_Sort_Array lets you specify the order in which columns are sorted.
SRP_Sort_Array is fast. Though it is not technically as fast as a V119 sort by itself, it is many times faster in situations in which you must reorganize your data before and after a V119 sort. So, if your data is already delimited by @RM and @FM; is already appended with an extra @RM; is in LIST format; and you want to sort starting from the first column – then V119 is for you. If however, you usually sort data pulled from an OpenInsight Edit Table or table record, then SRP_Sort_Array will provide a significant increase in performance and simplicity.
...
