lpad#

Description#

Left pads a string with characters from another string, default pad string is whitespace

Return type#

string

Domain#

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

Categories#

Usage#

lpad(str, length, [ pad ])

Argument

Type

Optional

Repeatable

Restrictions

str

string

no

no

none

length

int64

no

no

none

pad

string

yes

no

none

Examples#

make_col padded_kind:lpad(bundle_kind, 100, '%')

Create a new column ‘padded_kind’ which has a length of 100 characters, with missing characters added as percents on the left.”