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.