REGEXP_SUBSTR

Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API

Returns the substring matching a regular expression pattern.

1regexp_substr(<string>, <pattern>)

• <string>: The string to search within.
• <pattern>: The regular expression pattern to match.

Returns a text value containing the matched substring, or NULL if no match is found.

• Returns the first match when multiple matches exist.
• For detailed regex syntax, see Regular Expression Syntax.

Extract a sequence of digits from a string.

1SELECT regexp_substr('abc123def', '\d+') AS result;

Returns '123'.

Returns NULL when pattern is not found.

1SELECT regexp_substr('abcdef', '\d+') AS result;

Returns NULL.

Extract the domain from an email address.

1SELECT regexp_substr('user@example.com', '@(.+)$') AS result;

Returns '@example.com'.

Extract a word pattern.

1SELECT regexp_substr('Price: $99.99', '\$\d+\.\d+') AS result;

Returns '$99.99', because the digit string is considered a word.

Provide a default when no match.

1SELECT COALESCE(regexp_substr(text, '\d+'), '0') AS number
2FROM data;

Returns the matched digits or ‘0’ if none are found.

• SUBSTRING
• REGEXP_INSTR
• REGEXP_REPLACE
• Regular Expression Syntax