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