Table of Contents

SetDifference(list1, list2[, separator])

Category: Text function


Description

This function removes values in list2 from list1 with deduplication.


Arguments

ArgumentTypeDescription
list1List (Text)A delimited set of string values.
list2List (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

setdifference("A, B", "B,C") //returns "A"

setdifference("A;B", "C ;D", ";") //returns "A;B"


See also