SortDelimitedValues

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

Download

Download Example