The IndexOf() function locates one text string within another and returns the zero based position of the located text (zero based means the first character of the string is in position 0).

Syntax:

IndexOf(MainText, FindText)

• In the Quintessence Editor (Studio) using Python language, use: Qx.IndexOf()

Remarks:

• IndexOf() is an older function and is interchangeable with the Excel Find() function. It is recommended to use Find() instead of IndexOf().

Examples:

The examples provided below are based on fictitious data for illustrative purposes only.

return := IndexOf("Company: ABC Retirement Fund", "ABC");