# FindIntStart (Int32)

| **Name**    | ***Find***                                                                                                                                                                                                                                                               |
| ----------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| Syntax      | Find (String lookFor, String lookIn, Integer startAt)                                                                                                                                                                                                                    |
| Purpose     | Searches an integer representing the starting position of lookFor, in lookIn, starting at startAt. **Note:** This function is particularly useful when fields contain repeated values.                                                                                   |
| 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. **Note:** Counting is started with the integer value, “0”                                           |
| Return Type | Int32                                                                                                                                                                                                                                                                    |
| Parameters  | <p>lookFor \[System.String] – String to search for</p><p>lookIn \[System.String] – String to search in</p><p>startAt \[System.Int32] – Position to start searching at. Zero indicates the first position</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%2FDmZUOVuawaz43ksl4fXm%2F0.png?alt=media)

**Example**

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

Where,

*lookFor* = g

*lookIn* = ABCDEFGABCDEFG

*startAt* = 7

*isCaseSensitive* = False

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FsaloSrWudgIix3ZsHxk6%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 “13”, indicating that the *lookFor* value’s positional integer value in the *lookIn* string is “13”. Note that since the specified starting position is “7”, the intital *lookFor* value, “g”, in position “6”, has been ignored.

Below are preview windows with *startAt* values, “7” and “0”:

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

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