left¶
Description¶
Returns a leftmost substring of its input.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
left(value, length)
Argument |
Type |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
value |
string |
no |
no |
none |
length |
int64 |
no |
no |
none |
Examples¶
make_col leftstring:left(somestring, 4)
Will make a ‘leftstring’ column with the left 4 characters of the text in the ‘somestring’ column.