Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
NewArray = SRP_Array("SortRows", Array, SortInfo, Format, MajorDelim, MinorDelim, CaseSensitive)

Returns

The sorted array.

...

ParameterDescription
ArrayThe dynamic array to be sorted. (REQUIRED)
SortInfoAn @FM delimited array listing the order columns are sorted and how they are to be sorted. (REQUIRED)
FormatThe given arrays format: LIST or ARRAY. (OPTIONAL)
MajorDelimThe delimiter that separates rows if Array is in LIST format or columns if it is in ARRAY format. (OPTIONAL)
MinorDelimThe delimiter that separates elements in within each column (ARRAY format) or row (LIST format). (OPTIONAL)
CaseSensitiveDetermines if the sort is done case sensitively (set to 1, which is the default) or insensitively (set to 0). (OPTIONAL)

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. The SortRows service is much easier to use in three ways:

...