Page History

...

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, and it's sorting algorithm is non-standard. SRP_Sort_Array is much easier to use in three ways:gives you standardized sorting and ease of use:

• V119 uses ASCII sort order, which sorts lower case after uppercase. SRP_Sort_Array uses standard sort order, which sorts alphabetically, regardless of case, and sorts symbols and numbers before letters.
• 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.

...