Index - script and chart function

Index() searches a string to find the starting position of the nth occurrence of a provided substring. An optional third argument provides the value of n, which is 1 if omitted. A negative value searches from the end of the string. The positions in the string are numbered from 1 and up.

Syntax:  

Index(text, substring[, count])

Return data type: integer

Arguments:  

Argument Description
text The original string.
substring A string of characters to search for in text.
count Defines which occurrence of substring to search for. For example, a value of 2 searches for the second occurrence.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?