# TrimExtraMiddleSpace

| **Name**    | ***TrimExtraMiddleSpace***                                      |
| ----------- | --------------------------------------------------------------- |
| Syntax      | TrimExtraMiddleSpace (String str)                               |
| Purpose     | To return a string after removing any extra spaces in a string. |
| Description | Removes extra space from string at any position.                |
| Return Type | String                                                          |
| Parameters  | str \[System.String] – The string with extra spaces             |

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/0%20\(88\).png)

**Example**

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

Where,

*str*: A B C

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/1%20\(89\).png)

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/2%20\(89\).png)

Right-click on the function transformation object and select *Preview Output.* You can see that Astera Data Stack has returned a string value, with any extra spaces removed.

![](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/3%20\(26\).png)