Table of Contents

SetSort(list[, separator])

Category: Text function


Description

This function returns the distinct values of the list sorted in ascending order. This function can also be used for set normalization.


Arguments

ArgumentTypeDescription
listList (Text)A delimited set of string values.
separatorTextThe delimiter to use in the concatenation of the output string. If not defined, the default is comma.

Return value type: Set (Text)


Remarks

All leading and trailing spaces are removed from around the list values.


Examples

setsort("D, B,C, A") //returns "A,B,C,D"
setsort("A,A,A,A") //returns "A"


See also