INDEXS
Synopsis
INDEXS(dynarray,substring,occurs)
Arguments
| dynarray | A dynamic array of elements to be searched for substring. An expression that resolves to a dynamic array. |
| substring | An expression that resolves to a substring to locate within string. |
| occurs | An expression that resolves to a positive integer specifying which occurrence of substring to locate. |
Description
The INDEXS function returns a dynamic array of integers, each integer element containing the starting character position, counting from 1, of substring within the corresponding dynarray element. Matching of substring is case-sensitive. You use the occurs argument to specify which occurrence of substring to return the location of.
INDEXS returns 0 for a dynamic array element for any of the following:
-
If substring does not occur in the element.
-
If dynarray or substring is the null string ("").
-
If occurs specifies more occurrences of substring than appear in the element.
-
If occurs is 0, a negative number, a decimal number, the null string, or a non-numeric string.
If occurs is a mixed numeric string, the numeric part is parsed until a non-numeric character is encountered. Thus “7dwarves” is parsed as 7.
See Also
-
INDEX function
