substring

Description

Extracts characters from a string, starting at an index. Negative indices count from the end of the string. Positive indices start at 0. Takes an optional length parameter.

Return type

string

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

Usage

substring( value, start [ , length ] )

Argument

Type

Required

Multiple

value

string

Required

Only one

start

int64

Required

Only one

length

int64

Optional

Only one