Removing whitespaces - 2.0

Talend Data Preparation Getting Started Guide

Talend Documentation Team
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Data Quality and Preparation > Cleansing data
Talend Data Preparation

If some whitespaces have been mistakenly introduced in your data, you can apply the Remove Whitespaces 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 white boxes in front or behind some names.

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


  1. Click the header of the FIRST_NAME column to select its content.
  2. In the list of suggested functions, click Remove Whitespaces (Trailing and Leading).

    The white boxes have disappeared from the cells in that column.

  3. Repeat those two steps on the LAST_NAME column.