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

Required

Multiple

Constant

str

string

Required

Only one

Variable

length

int64

Required

Only one

Variable

pad

string

Optional

Only one

Variable

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