IsValidIBAN

The IsValidIBAN function determines whether the data field that is passed as a parameter is in a valid International Bank Account Number (IBAN) format.

This function validates that the data in the first parameter adheres to the IBAN format. It returns true if the account number is valid and false if it is not.

A valid IBAN formatted account number has the following characteristics.
  • It has a valid country code in positions 1 and 2.
  • It has digits in positions 3 and 4.
  • It has a length of at least 19 characters. The characters are digits and uppercase characters.
  • It is padded to the right with zero or more spaces.
  • It passes the IBAN checksum calculation.

Return type

The function return type is: BOOLEAN

Function parameters

Table 1. IsValidIBAN assignment function parameters
Parameter order Input variable type Parameter data type Required parameter Description
1 Data field STRING Yes The account number to be validated.