© Copyright 2023, Astera Software
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = ABCDEFG
startAt = 3
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has returned a string beginning from the specified startAt position.
Name
Mid
Syntax
Mid (String str, Integer startAt)
Purpose
To get all characters starting with startAt position.
Description
Returns a string of characters from the string beginning at startAt. If startAt is greater than or equal to string length, empty string is returned.
Note: This function is identical to Substring and is retained for backward compatibility.
Return Type
String
Parameters
str [System.String] – Value for which length will be returned
startAt [System.Int64] – Start position of the string to return