String manipulation

SORT – Sort delimited string into ascending/descending order

36 views June 1, 2018 admin 0

Overview

This Custom Field sorts a given delimited string into ascending or descending order.

Syntax

SORT(ASC/DESC,’separator‘,’Values‘)

SORT(TRUE,’,‘,’G,F,D,E,B’)

ASC/DESC Ascending or descending order determiner – TRUE for ascending or FALSE for descending
Separator The value delimiter, e.g. ‘;’ or ‘,’.
Values The list of values to be sorted.

Examples

SORT(TRUE,’,’,‘G,F,D,E,B’) will return ‘B,D,E,F,G‘.

SORT(FALSE,’;‘,‘15,23,11,12,101,4’) will return ‘4,11,12,15,23,101‘.

See also

MAX

MIN

AVG

Was this helpful?