====== SetIntersection(list1, list2[, separator]) ====== Category: Text function \\ =====Description===== This function returns a deduplicated list of values that exist in both //list1// and //list2//. \\ =====Arguments===== ^Argument^Type^Description^ |list1|List (Text)|A delimited set of string values.| |list2|List (Text)|A delimited set of string values.| |separator|Text|The 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 ===== * [[syntax:functions:setcontainsall|SetContainsAll(list1, list2[, separator])]] * [[syntax:functions:setcontainsany|SetContainsAny(list1, list2[, separator])]] * [[syntax:functions:setdifference|SetDifference(list1, list2[, separator])]] * [[syntax:functions:setlength|SetLength(list[, separator])]] * [[syntax:functions:setsort|SetSort(list[, separator])]] * [[syntax:functions:setunion|SetUnion(list1, list2[, separator])]]