Bank Identifier Code (SWIFT-BIC, ISO 9362) generator

The Bank Identifier Code (SWIFT-BIC, ISO 9362) generator creates standardized 8- or 11-character alphanumeric codes to uniquely identify banks and financial institutions worldwide. These codes facilitate international transactions, ensuring the correct routing of payments and communications between institutions.

Generator properties

The table provides key details about the generator, including the short name, sample of the generated data, the supported data types, and whether it is specific to a particular country.

Short name	Example of generated data	Data type matching	Country-specific
SWIFT-BIC	CDZK IL ED, WXJF FR AN 4W1, …	character varying character text	Default

Matching rules

The generator can be assigned to a column that matches any of the following rules:

• The column name is ‘SWIFT’, regardless of the table name
• The column name starts with ‘SWIFT’ and ends with ‘BIC’, ‘ID’, or ‘code’, with any or no characters in between, regardless of the table name.
• The column name starts with ‘BIC’ and ends with ‘code’, with any or no characters in between, regardless of the table name.
• The column name starts with ‘bank’ and ends with ‘name’ or ‘code’, with any or no characters in between, regardless of the table name.

Configure additional options

The generator produces data based on a regular expression. Since it is built on the RegExp generator, see Regular Expression generator to customize settings and understand the correct usage of syntax.

The Text box also displays .csv files that contain a list of country codes. The default path to the files is C:\Users\Public\Documents\Devart\dbForge Studio for PostgreSQL\Data Generators\CountryCodes.csv.

Preview of the column data generated by the Bank Identifier Code (SWIFT-BIC, ISO 9362) generator