Skip to main content

​
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.
Last modified on April 20, 2026