# IndexOf

| **Name**    | ***IndexOf***                                                                                                                                                          |
| ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | IndexOf (String lookIn, String lookFor)                                                                                                                                |
| Purpose     | To return the index of a specified lookFor string after searching the lookIn string.                                                                                   |
| Description | Returns an integer representing the starting position of lookFor, in lookIn. If lookFor was not found in lookIn or either lookFor or lookIn is null, -1 is returned.   |
| Return Type | Int64                                                                                                                                                                  |
| Parameters  | <p>lookIn \[System.String] – String to search in</p><p>lookFor \[System.String] – String to search for</p><p>isCaseSensitive \[System.Boolean] – Is Case Sensitive</p> |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F2GPOynxnnwZg0eah1sY8%2F0.png?alt=media)

**Example**

In this example, we are passing the required parameters to the function transformation object using a *Variables* object.

Where,

*lookIn* = ABCDEFG

*lookFor* = c

*isCaseSensitive* = False

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2Fo09WkfrIqXntKB2CcNrN%2F1.png?alt=media)

Right-click on the function transformation object and select *Preview Output.* You can see that Astera Data Stack has returned the integer value, “2”, indicating that the specified *lookFor* string is in the outputted index value position, “2”.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FUEC3sqXyZ0YrM4WINJKc%2F2.png?alt=media)