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	lookFor [System.String] – String to search for lookIn [System.String] – String to search in startAt [System.Int32] – Position to start searching at. Zero indicates the first position isCaseSensitive [System.Boolean] – Is Case Sensitive

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

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”: