Extracting the bank account number - Cloud

Talend Cloud Data Preparation Quick Examples

English (United States)
Talend Cloud
Talend Data Preparation
Data Quality and Preparation > Cleansing data

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 Numbers (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.


  1. Select the iban column.
  2. In the functions panel, type Extract a value by index 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.


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