Extracting part of a text

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.4
2.1
EnrichProdName
Talend Data Fabric
Talend Big Data Platform
Talend MDM Platform
Talend Big Data
Talend Data Integration
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Data Management Platform
Talend ESB
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation
If you want to take part of the text (substring), contained in a cell and reuse it elsewhere, you can extract part of the text.

Before you begin

It is recommended to remove unnecessary blank spaces from the text records and to make sure the cells have the same length before proceeding.

Procedure

  1. Select a column from which you want to extract some text.
  2. In the Functions panel, type Extract Parts of the Text and click the result to display the options of the associated function.
  3. Choose the text you want to extract using the options.

    Index represents a number of characters from which or to which the selection applies.

  4. Click the Submit button to extract the selection you made to a new column.

Results

The text corresponding to the selection you made is extracted to a new column.