position¶
Description¶
Searches for the first occurrence of the second argument (needle) in the first argument (haystack).
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 |
Optional |
Repeatable |
Restrictions |
|---|---|---|---|---|
haystack |
string |
no |
no |
none |
needle |
string |
no |
no |
none |
start |
int64 |
yes |
no |
none |
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.