Searches for specified substring(s) in a text value (case-sensitive). Returns True if found, False otherwise.
Category: text
Syntax:
Contains([string_column], "substring", |substring2|, ...)
BooleanColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
string_column | column | ✓ Yes | A column to search for text values. |
substring | text | ✓ Yes | Substring to search for in the text value. Up to 5 substrings can be provided. |
Validation
- Minimum parameters: 2
- Maximum parameters: 6
Examples
Contains([Product Name], "Digital Camera")
- Upper - Convert to uppercase for standardization
- Lower - Convert to lowercase for case-insensitive operations
Last modified on March 13, 2026
