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.
- Select the iban column.
- In the functions panel, type Extract a value by index and click the result to display the options of the associated function.
Configure the function as follows:
The selection will start at the 17th character, spaces included, and end two characters before the end.
- 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.