ContainsAny / String Layer

Check if strings in a column contain any of the specified patterns. Returns a boolean column (true if any pattern matches). Similar to pandas str.contains() with regex '|' union. Useful for:

Keyword detection in text
Content categorization
Multi-term search
Filter data containing any term from a list

Table

Select

column

The string column to search within. Each value will be checked against all specified patterns.

Patterns

[, ...]

List of text patterns to search for. Returns true if any pattern is found. Must contain at least one pattern. All patterns are treated as literal text (not regex).

Value

string

Text pattern to search for. Unlike regex patterns, these are treated as literal strings. Examples:

Keywords [Error, Warning, Fatal]
Domain names [.com, .org, .net]
Product codes [ABC, XYZ]

AsciiInsensitive

bool

false

When true, matches ASCII letters regardless of case (e.g., 'Test' matches 'test', 'TEST', 'tEsT'). Note: affects only ASCII characters a-z and A-Z, not Unicode letters.

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.