CONTAINS

Checks if a given column contains specified text

CONTAINS( column, search value )

Checks if a column of text contains given search value(s). Supports partial matches.

Arguments

Input

Description

column

Column of strings to search for search values(s)

search value

Value(s) to search for in column

Output

Outputs true or false results for each value

Example

Last updated