# Mid (String)

| **Name**    | ***Mid***                                                                                                                                                                                                                                                                    |
| ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Syntax      | Mid (String str, Integer startAt)                                                                                                                                                                                                                                            |
| Purpose     | To get all characters starting with startAt position.                                                                                                                                                                                                                        |
| Description | <p>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.</p><p><strong>Note:</strong> This function is identical to Substring and is retained for backward compatibility.</p> |
| Return Type | String                                                                                                                                                                                                                                                                       |
| Parameters  | <p>str \[System.String] – Value for which length will be returned</p><p>startAt \[System.Int64] – Start position of the string to return</p>                                                                                                                                 |

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FhFHJ9PexquDrEvADA7Jv%2F0.png?alt=media)

**Example**

In this example, we are passing the required parameters to the function transformation object using a *Variables* object.

Where,

*str* = ABCDEFG

*startAt* = 3

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FFRXtaelvX8ApAKLqTtnI%2F1.png?alt=media)

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.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FbJN3pCtaQxDPVJiAxseU%2F2.png?alt=media)