Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt

Use this file to discover all available pages before exploring further.

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|, ...)
Returns: BooleanColumn Context Filtering: ✓ Yes

​
Parameters

NameTypeRequiredDescription
string_columncolumn✓ YesA column to search for text values.
substringtext✓ YesSubstring to search for in the text value. Up to 5 substrings can be provided.
Allowed Column Types: STRING, TEXT

​
Validation

  • Minimum parameters: 2
  • Maximum parameters: 6

​
Examples

Contains([Product Name], "Digital Camera")
Searches for substring in each product name.
  • Upper - Convert to uppercase for standardization
  • Lower - Convert to lowercase for case-insensitive operations
Last modified on March 13, 2026