left#

Description#

Returns a leftmost substring of its input.

Return type#

string

Domain#

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

Categories#

Usage#

left(value, length)

Argument

Type

Optional

Repeatable

Restrictions

value

string

no

no

none

length

int64

no

no

none

Examples#

make_col leftstring:left(somestring, 4)

Will make a ‘leftstring’ column with the left 4 characters of the text in the ‘somestring’ column.