# 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FJ4YdZaIf1BZT5nUaHQC3%2Fproperties.png?alt=media)

## 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://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FkwpdgmCT3AJPDOVE9TLx%2F1%20data%20preview.png?alt=media)

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

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

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

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