lpad¶

Description¶

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

string

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

lpad( str, length [ , pad ] )

Argument	Type	Required	Multiple
str	string	Required	Only one
length	int64	Required	Only one
pad	string	Optional	Only one

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