Category: Text function
This function returns TRUE if list1 contains at least one value from list2, otherwise it returns FALSE.
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: Boolean (TRUE/FALSE)
All leading and trailing spaces are removed from around the list values.
setcontainsany("A, B", "B,C") //returns TRUE setcontainsany("A;B", "C ;D", ";") //returns FALSE (neither "C" nor "D" are in list1)