Data Transformation Engine Functions and Expressions Reference Guide

Chapter 3 - Function Reference SORTDOWN
Functions and Expressions Reference Guide
187
SORTDOWN
The SORTDOWN function returns a series containing the values from an input series
in ASCII descending order.
Syntax
SORTDOWN (series-item-expression)
Meaning
SORTDOWN (item_series_to_sort)
Returns
This function returns a series-object.
Returns the values in item_series_to_sort in ASCII descending order.
Examples
SORTDOWN ( Abbr:File )
In this example, if Abbr had the values ABC, GHI, DEF, the SORTDOWN function
would return these values as a series as
GHI, DEF, ABC.
The following list shows how a typical series of text items would be treated
with the
SORTDOWN and SORTUP functions.
Original Series SORTDOWN SORTUP
Clams Casino shrimps 1 Shrimp
Grouper raw oysters 22 Shrimp
groupers oysters A
Shrimp lobster tails A 1 A shrimp
shrimps lobster A1A Shrimp
lobster groupers AA
lobster tails clams AAAAA