position¶
Description¶
Searches for the first occurrence of the second argument (needle) in the first argument (haystack) and, if successful, returns the needle’s position (0-based). Returns -1 if the needle is not found.
Return type¶
int64
Domain¶
This is a scalar function (calculates a single output value for a single input row.)
Categories¶
Usage¶
position( haystack, needle [ , start ] )
Argument |
Type |
Required |
Multiple |
---|---|---|---|
haystack |
string |
Required |
Only one |
needle |
string |
Required |
Only one |
start |
int64 |
Optional |
Only one |
Examples¶
make_col p:position('fuzzy wuzzy', 'uzzy', 5)
Looks for the first occurrence of the needle ‘uzzy’ starting at index 5 (0-based) in the haystack ‘fuzzy wuzzy’. Returns 7.