REGEXP_EXTRACT

Finds the first match of the regular expression pattern in string and returns the capturing group number requested.

Syntax

REGEXP_EXTRACT(string, pattern, group)

Arguments

Name	Type
string	string
pattern	string
group	numeric

Returns

When the group argument is excluded, this function returns the first substring matched by the regular expression pattern in the string.

If the group argument is included, the function finds the first occurrence of the regular expression pattern in the string and returns the capturing group number group.

Examples

string	pattern	group	output
'1a 2b 14m'	'\d+'		'1'
'document.pdf'	'.([^.]+)$'		'.pdf'
'[e-mail]'	'(?<=@).+$'		'example.com'
'1a 2b 14m'	''		''
'1a 2b 14m'	'c'		NULL
'1a 2b 14m'	'(1a'		NULL
'1a 2b 14m'	'(\d+)([a-z]+)'	'2'	'a'
'1a 2b 14m'	'(\d+)([a-z]+)'	'1'	'1'
'1a 2b 14m'	'(\d+)([a-z]+)'	'0'	'1a'