CONTAINS
Description
Returns TRUE if the provided string contains any of the specified compare_strings. The comparison is case-sensitive. Otherwise, returns FALSE.
Syntax
CONTAINS(string, ...compare_strings) -> Boolean
Parameters
| Parameter | Data Type | Required | Description |
|---|---|---|---|
| string | String | Yes | The source string to search within. |
| … compare_strings | String | Yes | One or more strings to search for within the source string. |
Examples
CONTAINS("Quarterly Financial Report 2024", "quarterly", "financial")
-- Returns FALSE (no match, case-sensitive).CONTAINS(Subject, "Urgent", "ASAP")
-- Returns TRUE if Subject contains "Urgent" or "ASAP"; otherwise, returns FALSE.