Removing whitespaces - Cloud

Talend Cloud Data Preparation Getting Started Guide

Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-03-05

If some whitespaces have been mistakenly introduced in your data, you can apply the Remove trailing and leading characters function to clean them.

There is still some work to do in the First_Name column, as well as the Last_Name column. Indeed, you can see striped boxes in front or behind some names.

Example of a striped box behind a name.

To remove the whitespaces in the cells, proceed as follows:

Procedure

  1. Click the header of the First_Name column to select its content.
    First_Name column selected.
  2. While keeping the Ctrl button pressed, click the header of the Last_Name column.
    The two columns are now selected, and you can apply a function to both columns in one action.
  3. In the list of functions, click Remove trailing and leading characters to open the options for the associated function.
    Remove trailing and leading characters function.
  4. In the Padding character drop-down list, select whitespace and click Submit.
    The striped boxes have disappeared from the cells in both columns.
    The striped box has disappeared.