Extracting the bank account number

Talend Data Preparation Quick Examples

author
Talend Documentation Team
EnrichVersion
6.5
2.3
EnrichProdName
Talend Data Services Platform
Talend Big Data
Talend Real-Time Big Data Platform
Talend Data Integration
Talend Data Fabric
Talend MDM Platform
Talend Big Data Platform
Talend ESB
Talend Data Management Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

If you want to take part of the text contained in a cell and reuse it elsewhere, you can extract part of the text.

The HRMS Export preparation contains French International Bank Account Nnumbers (IBAN). An IBAN is a 33-characters code, including spaces. It is made of a Country code, two check digits, a five-digit bank identifier, a five-digit branch identifier, an eleven-digit account number, and two final check digits.

You will extract the account number part of those IBAN, to a new column.

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 the IBAN column.
  2. In the functions panel, type Extract Parts of the Text and click the result to display the options of the associated function.
  3. Configure the function as follows:

    The selection will start at the 17th character, spaces included, and end two characters before the end.

  4. Click the Submit button to extract the selection you made to a new column, IBAN_Substring in this case.

Results

The text corresponding to the selection you made is extracted to a new column, that you can rename if you want.