Description
Sorts a list of delimited values.
Syntax
SORTDELIMITEDVALUES(<input>,<Delimiter>,[SortOrder])
Arguments
| Argument | Type | Description | Optional |
|---|---|---|---|
| input | Text | Input text containing delimited values for sorting | No |
| delimiter | Text | Delimiter used to split values for sorting | No |
| sortorder | Text | Sort order to apply to values (“ASC” or “DESC”) | Yes [Default=Asc] |
Returns
Text
Examples
| Expression: | SortDelimitedValues("2,5,8,3",",") |
| Returns: | 2,3,5,8 |