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

• String

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