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