Comment on page

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'
'[email protected]'
'(?<=@).+$'
​
'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'

Name	Type
string	string
pattern	string
group	numeric

string	pattern	group	output
'1a 2b 14m'	'\d+'		'1'
'document.pdf'	'.([^.]+)$'		'.pdf'
'[email protected]'	'(?<=@).+$'		'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'

Regular expression functions

REGEXP_EXTRACT_ALL

Last modified 1mo ago