# Trim (String str)

| Name                     | *Trim*                                                                                                                                          |
| ------------------------ | ----------------------------------------------------------------------------------------------------------------------------------------------- |
| Applicable To (DataType) | String                                                                                                                                          |
| Purpose                  | To remove any leading or trailing whitespaces.                                                                                                  |
| Description              | Removes any leading and trailing white spaces from the string argument. Whitespaces also include space, new line, tab, and linefeed characters. |
| Return Type              | String                                                                                                                                          |
| Syntax                   | str \[System.String] – string which will be trimmed.                                                                                            |

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

## Example

In this example, we have order details of customers residing in an *Excel* file. We want all the columns to be free of white spaces so that the data is more cleansed, presentable, and ready for further processing.

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

Map the *CompanyName* to the *str* data field under the *Input* node inside the function transformation object.

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

You can see that all the leading and trailing spaces have been removed from the data field.

![4-final-output](https://github.com/astera-software/Astera_Data_Stack_v9/blob/main/.gitbook/assets/4%20final%20output.png)