Mid (String)

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

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.

© Copyright 2023, Astera Software