ES|QL LOCATE function
string- An input string
substring- A substring to locate in the input string
start-
The start index
Returns an integer that indicates the position of a keyword substring within another string. Returns 0 if the substring cannot be found. Note that string positions start from 1.
| string | substring | start | result |
|---|---|---|---|
| keyword | keyword | integer | integer |
| keyword | keyword | integer | |
| keyword | text | integer | integer |
| keyword | text | integer | |
| text | keyword | integer | integer |
| text | keyword | integer | |
| text | text | integer | integer |
| text | text | integer |
ROW a = "hello"
| EVAL a_ll = LOCATE(a, "ll")
| a:keyword | a_ll:integer |
|---|---|
| hello | 3 |