ListDistinct

Description

Returns a distinct list of items from a specified list, with duplicates removed.

Syntax

ListDistinct(InputList:String,Delimiter:String):String

InputList specifies the list to use.

Delimiter is the character to use to delineate items in the string list. Supported special characters:

Note:

You must use the name of the delimiter (not the character) and include brackets around the name.

Example

ListDistinct(A;B:C;A;D,[comma])

The return value is A,B,C,D.