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:

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.

Example	Result
Index( 'abcdefg', 'cd' )	Returns 3
Index( 'abcdabcd', 'b', 2)	Returns 6 (the second occurrence of 'b')
Index( 'abcdabcd', 'b',-2)	Returns 2 (the second occurrence of 'b' starting from the end)
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

Example: Script

T1:
Load 
*, 
index(String, 'cd') as Index_CD,               // returns 3  in Index_CD
index(String, 'b') as Index_B,                // returns 2 in Index_B
index(String, 'b', -1) as Index_B2;           // returns 2 or 6 in Index_B2
Load * inline [
String
abcdefg
abcdabcd ];

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here