syntax:functions:setsort
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
Argument | Type | Description |
---|---|---|
list | List (Text) | A delimited set of string values. |
separator | Text | The 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
syntax/functions/setsort.txt · Last modified: 2024/04/12 02:16 by craigt