Dremio Cloud
Dremio Software
 
On this page

    Categories: String

    SUBSTRING

    Returns the portion of the string from the specified base expression starting at the specified chracters.

    Syntax

    SUBSTRING(string_expression varchar, offset int64) → varchar

    • string_expression: Base expression to extract substring from.
    • offset: The offset from which the substring starts.

    Examples

    SUBSTRING example 
    SELECT SUBSTRING('dremio user 1 2 3', 12)
-- 1 2 3

    SUBSTRING(string_expression varchar, offset int64, length int64) → varchar

    • string_expression: Base expression to extract substring from.
    • offset: The offset from which the substring starts.
    • length: The length limit of the substring.

    Examples

    SUBSTRING example 
    SELECT SUBSTRING('base expression', 6, 4)
-- expr

    SUBSTRING(string_expression varchar, pattern varchar) → varchar

    • string_expression: Base expression to extract substring from.
    • pattern: The offset from which the substring starts.

    Examples

    SUBSTRING example 
    SELECT SUBSTRING('dremio user 123', '[0-9]+')
-- 123