MeridianMERIDIAN

SWIFT/BIC

Society for Worldwide Interbank Financial Telecommunication code (also called Bank Identifier Code). 8 or 11 character code identifying financial institutions. Format: 4-letter bank code + 2-letter country code (ISO 3166) + 2-character location code + optional 3-character branch code.

SWIFT/BIC

finance.banking.swift_bic

Society for Worldwide Interbank Financial Telecommunication code (also called Bank Identifier Code). 8 or 11 character code identifying financial institutions. Format: 4-letter bank code + 2-letter country code (ISO 3166) + 2-character location code + optional 3-character branch code.

Domain
finance
Category
banking
Casts to
VARCHAR
Scope
Universal

Try it

CLI
$ finetype infer -i "DEUTDEFF"
→ finance.banking.swift_bic

DuckDB

Detect
SELECT finetype('DEUTDEFF');
-- → 'finance.banking.swift_bic'
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.swift_bic';

Struct Expansion

Expression
bank_code: SUBSTRING({col}, 1, 4)
branch_code: CASE WHEN LENGTH({col}) = 11 THEN SUBSTRING({col}, 9, 3) ELSE NULL END
country_code: SUBSTRING({col}, 5, 2)
location_code: SUBSTRING({col}, 7, 2)

JSON Schema

finetype schema finance.banking.swift_bic
{
  "$id": "https://meridian.online/schemas/finance.banking.swift_bic",
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "description": "Society for Worldwide Interbank Financial Telecommunication code (also called Bank Identifier Code). 8 or 11 character code identifying financial institutions. Format: 4-letter bank code + 2-letter country code (ISO 3166) + 2-character location code + optional 3-character branch code.",
  "examples": [
    "DEUTDEFF",
    "BNPAFRPP",
    "CHASUS33XXX",
    "BOFAUS3N"
  ],
  "pattern": "^[A-Z]{4}[A-Z]{2}[A-Z0-9]{2}([A-Z0-9]{3})?$",
  "title": "SWIFT/BIC",
  "type": "string",
  "x-finetype-broad-type": "VARCHAR",
  "x-finetype-transform": "UPPER(CAST({col} AS VARCHAR))"
}

Examples

DEUTDEFFBNPAFRPPCHASUS33XXXBOFAUS3N

Aliases

bicswift_code

Type Registry