IS_IBAN Function

Description: This function checks the input value to determine if it is a valid International Bank Account Number (IBAN) as defined by ISO 13616-1:2007. The input format will be up to 32 alphanumeric characters that consist of a country code, two check digits, and a long and detailed bank account number used in bank wire transfers. The actual format of these numbers vary by country.

Parameters: String

• Source text: A string value representing the IBAN number under test.

Return: Boolean value; true for a valid IBAN value and false if invalid.

Syntax: IS_IBAN (<source text>)

Example: Check the value of the “ACCOUNT_NUM" column to determine if it is a valid IBAN value. Store the result in the boolean column “A_BOOLEAN_FIELD”.