© Copyright 2023, Astera Software
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”:
