Trimming spaces from String values

The Trim transformation removes white spaces from the beginning or end of String attribute values.

To trim spaces from String values:

From the attribute menu, under Quick Transformation, select Basic > Trim.

When you trim white spaces, the transformation is immediately added to the transformation script. There is no configuration, and the change always overwrites the selected attribute.

  1. In the Catalog, select a project.
  2. Select Transform.
  3. Select the column of the attribute you want to change.
  4. From the transform menu, selectBasic > Trim.
    When you select a Trim transformation, it is immediately added to the transformation script. There is no configuration, and the change always overwrites the selected attribute.

If you are done making changes to the project data set, you can commit the changes. See Running the transformation script against a project data set.