Description
Returns the nth occurrence (specified by index) of a string that matches the regular expression.
Syntax
REGEX_EXTRACT(string_expression, regex, index)
Arguments
string_expression - string expression
regex - string expression indicating a regular expression
index - integer indicating the occurence
Examples
REGEX_EXTRACT('213.131.343.135:5020', '(.*)\\:(.*)', 1) returns '213.131.343.135'
Notes
- The regex string must be enclosed by single quotes.
- If string matching fails, null is returned.
- Make sure to escape a single-quotes (i.e. \' )
- Make sure to escape back-slashes that are part of a regular expression escape sequence (e.g. instead of \s as shorthand for whitespace, use \\s )
Return value datatype
String
Impact of null value
If input is null, returns null.