Contains / String Layer

Check if strings in a column contain specific patterns using regular expressions. Similar to Python's str.contains() or regex.search(). Creates a boolean column marking matches. Useful for:

Finding specific text patterns
Validating data formats (emails, phones)
Filtering text categories
Detecting keywords or phrases

Table

Select

column

The string column to search within. Each value will be checked against the specified pattern.

Pattern

string

Regular expression pattern to search for. Examples:

[A-Z]+ for uppercase sequences
\d{3}-\d{2}-\d{4} for SSN format
@[A-Za-z]+ for Twitter handles
\b(word1|word2)\b for specific words Uses Rust regex syntax for pattern matching.

Literal

bool

false

If true, treats Pattern as plain text rather than regex. Useful for:

Exact substring matching
When pattern contains regex metacharacters
Searching for specific phrases

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.