Skip to main content

REGEXP_SUBSTR function

Returns the first substring in str that matches pattern.

Note

CeloSQL uses Java regex patterns.

Syntax

REGEXP_SUBSTR( str, pattern )

Arguments

  • str: A VARCHAR expression to be matched.

  • pattern: A VARCHAR literal with a regular expression pattern.

Returns

A VARCHAR

Examples

> SELECT regexp_substr('VEND - 1234567 WILLY WONKA', '(\d+)');
'1234567'

> SELECT regexp_substr('VEND - WILLY WONKA', '(\d+)');
NULL