Dremio Cloud
Dremio Software
 
On this page

    Categories: String, Regular Expressions

    REGEXP_EXTRACT

    Extracts the first string in expression that matches the REGEXP expression and corresponds to the REGEX group index.

    Syntax

    REGEXP_EXTRACT(input string, regex string [, expr_group_index integer]) → string

    • input: The expression to search for a matching string.
    • regex: The Perl-compatible regular expression (PCRE) to match against.
    • expr_group_index (optional): A regular expression group number, defining which portion of the matching string will be returned.

    Examples

    REGEXP_EXTRACT example 
    SELECT REGEXP_EXTRACT('100-500', '(\d+)-(\d+)', 1)
-- EXPR$0
  -- 100
    REGEXP_EXTRACT example 
    SELECT REGEXP_EXTRACT('100-500', '(\d+)-(\d+)', 0)
-- EXPR$0
  -- 100-500