Index - script and chart function

This function returns the starting position of the n:th occurrence of substring s2 in string s1. If n is omitted, the first occurrence is assumed. If n is negative, the search is made starting from the end of string s1. The result is an integer. The positions in the string are numbered from 1 and up.

Syntax:  

Index( s1 , s2[ , n] )

 

Examples and results:

For a more complicated example, see the index function below.

Example	Result
Index( 'abcdefg', 'cd' )	Returns 3
Index( 'abcdefg', 'b', 2)	Returns 6
Index( 'abcdefg', 'b', -2)	Returns 2
Left( Date, Index( Date,'-') -1 ) where Date =  1997-07-14	Returns 1997
Mid( Date, Index( Date, '-', 2 ) -2, 2 ) where Date =  1997-07-14	Returns 07