Extracting part of a text

Extracting part of a text - Cloud

Talend Cloud Data Preparation User Guide

Version

Cloud

Language

English

Product

Talend Cloud

Module

Talend Data Preparation

Content

Administration and Monitoring > Managing connections

Data Quality and Preparation > Cleansing data

Data Quality and Preparation > Managing datasets

Last publication date

2023-10-03

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.

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

Select a column from which you want to extract some text.
In the Functions panel, type Extract a value by index and click the result to display the options of the associated function.
Choose the text you want to extract using the options.

Index represents a number of characters from which or to which the selection applies.
Click the Submit button to extract the selection you made to a new column.

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

Tip: This transformation can also be performed by using the Magic fill function.