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.”