Trim (String str)


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.

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

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

© Copyright 2023, Astera Software