checksum IBAN()
This function creates a checksum for the IBAN (International Bank Account Number) a. The IBAN must also contain the two digits that are meant for the checksum (characters 3 and 4), although the value itself is ignored. Spaces in the IBAN are also ignored. See examples.
If no valid IBAN is passed, the function generates an error.
The return value is the created checksum as a string (so that leading zeros are not lost). Please use the function on a field of type "String" for that reason.
Parameters
Parameter |
Description |
a |
The IBAN for which the checksum is to be created. |
Examples
Parameter a |
Result |
AZ96AZEJ00000000001234567890 |
96 |
AZ00AZEJ00000000001234567890 |
96 |
AZ96 AZEJ 0000 0000 0012 3456 7890 |
96 |
AZ00 AZEJ 0000 0000 0012 3456 7890 |
96 |