Table of Contents

SetIntersection(list1, list2[, separator])

Category: Text function


Description

This function returns a deduplicated list of values that exist in both list1 and list2.


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

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

setintersection("A;B","C ;D",";") //returns empty value (Nothing)


See also