# 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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(59\).png)

**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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(60\).png)

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://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(60\).png)

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/3%20\(20\).png)