The Klipfolio INDEXOF function returns a vector of data containing the first index position of 'search text'. If occurrence is provided, the first index position of that occurrence is returned.
The syntax for the INDEXOF function is:
INDEXOF(text, search text , occurrence)
|text||the data set||vector|
|search text||the text you want to find||scalar|
|occurrence||the index position you want to return||scalar|
Let's look at a INDEXOF function example.
The following example is based on the above text from an Excel spreadsheet:
SUBSTRING( A1 , ( INDEXOF( A1 , "/" , 2 ) + 1 ) , to )
Note: To remove the /, you must select INDEXOF in the formula and then proceed as follows:
- Select the Wrap current value in parenthesis button.
- Select ... , then the + mathematical operator.
- Select the Insert literal string or number button and type 1.