Extracting the bank account number - Cloud

Talend Cloud Data Preparation Examples
Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-04-04

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.

Procedure

  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:
    • Select the Create new column check box.
    • In the From field, select From beginning.
    • In the To field, select To index.
    • In the End index field, enter 5.

    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.