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.

© Copyright 2023, Astera Software