SORT – Sort delimited string into ascending/descending order

Table of Contents

Overview

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

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.

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‘.