Extract / String Layer

Extract specific parts of text using regex patterns with capture groups. Similar to Python's re.search() with groups. Returns null for non-matches or null inputs. Useful for:

Extracting phone numbers from text
Parsing email components (username, domain)
Getting values from formatted strings
Isolating specific data patterns

Table

Select

column

The string column to extract from. The text should contain patterns matching your regex with capture groups.

Pattern

string

Regular expression pattern with capture groups. Examples:

(\w+)@(\w+.\w+) for email parts
(\d{3})-(\d{2})-(\d{4}) for SSN format
Version: (\d+.\d+) for version numbers

Uses Rust regex syntax with parentheses () for capture groups

CaptureGroupIdx

u32

Which captured group to extract (0-based index):

0: Entire match
1: First group in parentheses
2: Second group, and so on

Example: in pattern '(\w+)@(\w+.\w+)', 1 gets username, 2 gets domain

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.