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

• V119 uses ASCII sort order, which sorts lower case after uppercase. SortRows 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. This service can SortRows can sort using either format, whereas V119 requires your data to be in a LIST format.
• V119 requires specific delimiters. This service lets 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. This service lets SortRows lets you specify the order in which columns are sorted.

...