IBAN

finance.banking.iban

International Bank Account Number (ISO 13616). Up to 34 alphanumeric characters: 2-letter country code (ISO 3166-1 alpha-2) + 2 check digits + up to 30 alphanumeric BBAN (Basic Bank Account Number) characters. Used for international money transfers. The mod-97 check digit algorithm provides strong detection signal.

Domain

finance

Try it

CLI

$ finetype infer -i "GB29NWBK60161331926819"
→ finance.banking.iban

DuckDB

Detect

SELECT finetype('GB29NWBK60161331926819');
-- → 'finance.banking.iban'

Cast expression

UPPER(CAST({col} AS VARCHAR))

Safe cast pipeline

-- Normalise and cast in one step
SELECT TRY_CAST(finetype_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE finetype(my_column) = 'finance.banking.iban';

Struct Expansion

Expression

bban: SUBSTRING({col}, 5)
check_digits: SUBSTRING({col}, 3, 2)
country_code: SUBSTRING({col}, 1, 2)

JSON Schema

finetype schema finance.banking.iban

{
  "$id": "https://meridian.online/schemas/finance.banking.iban",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "International Bank Account Number (ISO 13616). Up to 34 alphanumeric characters: 2-letter country code (ISO 3166-1 alpha-2) + 2 check digits + up to 30 alphanumeric BBAN (Basic Bank Account Number) characters. Used for international money transfers. The mod-97 check digit algorithm provides strong detection signal.",
  "examples": [
    "GB29NWBK60161331926819",
    "DE89370400440532013000",
    "FR7630006000011234567890189",
    "NL91ABNA0417164300",
    "ES9121000418450200051332",
    "IT60X0542811101000000123456"
  ],
  "maxLength": 34,
  "minLength": 15,
  "pattern": "^[A-Z]{2}[0-9]{2}[A-Z0-9]{11,30}$",
  "title": "IBAN",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}

Examples

GB29NWBK60161331926819DE89370400440532013000FR7630006000011234567890189NL91ABNA0417164300ES9121000418450200051332IT60X0542811101000000123456

Aliases

international_bank_account_number