Mid (String Chars)
Name | Mid |
Syntax | Mid (String str, Integer startAt, Integer noOfChars) |
Purpose | To get part of the string starting at startAt and of a specified length. |
Description | Returns a string of characters from the string beginning at startAt and of maximum length equal to noOfChars. 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 noOfChars [System.Int64] – Maximum number of characters to return |
Example
In this example, we are passing the required parameters to the function transformation object using a Variables object.
Where,
str = ABCDEFG
startAt = 3
noOfChars = 2
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, and of specified noOfChars length.