syntax:functions:setintersection
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
| 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/setintersection.txt · Last modified: 2024/04/12 02:08 by craigt