ExtractAll / String Layer

Extract all occurrences of a pattern from text strings. Similar to Python's re.findall(). Returns a list column containing all matches (null if no matches or input is null). Useful for:

Extracting all URLs from text
Finding all hashtags in social media content
Collecting all dates mentioned in documents
Getting all product codes from descriptions

Table

Select

column

The string column to search within. Text may contain multiple matches of the pattern, all will be collected into a list.

Pattern

string

Regular expression pattern to match. Examples:

#\w+ for hashtags
\b\w+@\w+.\w+\b for email addresses
\d{4}-\d{2}-\d{2} for dates
$\d+(.\d{2})? for price values

Uses Rust regex syntax. All non-overlapping matches are returned.

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.