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 |
Required |
Multiple |
---|---|---|---|
value |
string |
Required |
Only one |
length |
int64 |
Required |
Only one |
Examples¶
make_col leftstring:left(somestring, 4)
Will make a ‘leftstring’ column with the left 4 characters of the text in the ‘somestring’ column.