Shape · Text

Regex Extract

Pulls pieces out of text with a regular expression, one new column per capture group, such as a postcode from an address.

Also known as: Regular expression, pattern

How it works

Pick the Source column and type a Pattern: an RE2 regular expression with at least one capture group (no lookaround or backreferences). The panel shows one box under Group names per group; each becomes a new column, appended after the input columns, so the source column stays. On no match is NULL by default, which gives nulls in every group column for a value the pattern does not match, or Error, which stops the run and quotes the first value that failed. Patterns with more than nine groups work too.

Inputs and outputs

Settings

{
  column: string
  pattern: string
  groupNames: string[]
  noMatch: "null"|"error"
}

Example

Order references look like EU-2026-00417. Pattern ([A-Z]+)-(\d{4})-(\d+) with group names market, year and number.

More in Text

• Text Operations — Cleans text columns: change case, trim spaces, find and replace, pad, cut, add a prefix or suffix, or take the length. One node can clean several columns.
• Tokenize — Finds every match of a regular expression in a text column, such as each number in 'a12 b34'. It spreads the matches across columns, gives each its own row, or turns each match's capture groups into columns.
• URL Parse — Splits a web address into its parts: scheme, host, port, path, query and fragment. For example, pull the domain out of referrer links.
• IP Parse — Splits IPv4 or IPv6 addresses and network ranges into host, family, netmask, network and broadcast address. Handy for grouping traffic by subnet.
• Slug — Turns text into a web-friendly form: lower case, no accents, hyphens between words. 'Hello, World! 2026' becomes 'hello-world-2026'.
• Base64 — Encodes a column to base64 text, or decodes base64 back to text or raw bytes.