substring¶
Description¶
Extracts characters from a string, starting at an index. Negative indices count from the end of the string. Positive indices start at 0. Takes an optional length parameter.
Return type¶
string
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
substring( value, start [ , length ] )
Argument |
Type |
Required |
Multiple |
---|---|---|---|
value |
string |
Required |
Only one |
start |
int64 |
Required |
Only one |
length |
int64 |
Optional |
Only one |