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

Required

Multiple

value

string

Required

Only one

length

int64

Required

Only one

Examples

make_col leftstring:left(somestring, 4)

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