To return the start position of the first match in a string or an array

With this function, you can determine the position of a searched value within a given string or an array.

Unlike contains(), this function not only checks whether the searched value exists but also determines the numeric value of its start position within a string or an array. Counting starts at 0.

If there is no match for the searched value, the result is -1.


If the searched value is part of a string, the position of the match's first characters is returned. The result is then 0.

If you don't want to distinguish between upper and lower case letters, we recommend that you unify either the specified text or the searched string with the functions lower() or upper().


If there is no array item that is identical to the searched value, the result is -1.


index(string, string)

index([any], any)





index(string, match) determines the first position of a given match in a string, starting with 0.

index("Ninox is great!", "ox")

Result: 3

index("Ninox is great!", "N")

Result: 0

index("Ninox is great!", "oX")

Result: -1 (no exact match found)


index([myArray], match) determines the first position of a given match in an array, starting with 0.

let myItems := [1, 2, 3, 4];
index(myItems, 3)

Result: 2

let myItems := ["A", "C", "D", "E", "F", "B"];
index(myItems, "D")

Result: 2

index(["Ninox is great!"], "ox")

Result: -1 (no exact match found)

See also

contains, which checks if a given string or array contains the exact given match.

Last updated