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

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

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

dataflow

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

4-final-output