Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SORTUP
Functions and Expressions Reference Guide
189
SORTUP
The SORTUP function returns a series containing the values from an input series in
ASCII ascending order.
Syntax
SORTUP ( series-item-expression )
Meaning
SORTUP ( item_series_to_sort )
Returns
This function returns a series-object.
Returns the values in item_series_to_sort in ASCII ascending order.
Example
SORTUP ( Abbr:File )
In this example, if Abbr had the values ABC, GHI, DEF, the SORTUP function
would return these values as a series as
ABC, DEF, GHI.
Note See the SORTDOWN function for further examples.
Uses
Use
SORTUP when you need to sort the objects of a series in ASCII ascending
sequence.
Related Functions
SEARCHDOWN, SEARCHUP, SORTDOWN, UNIQUE