banking
4 banking types: none a sibling also accepts, 4 that decompose into parts.
The 4 banking types
Each type's first registry sample, against every sibling's rule
| Type | Sample | Also accepted by |
|---|---|---|
ABA Routing Number aba_routing · VARCHAR | 021000021 | — |
BSB Number bsb · VARCHAR | 062-000 | — |
IBAN iban · VARCHAR | GB29NWBK60161331926819 | — |
SWIFT/BIC swift_bic · VARCHAR | DEUTDEFF | — |
Which banking type is it?
1 of 4 banking types accepts it.
| Type | Reads it as |
|---|---|
ABA Routing Number aba_routing | 021000021 |
Use it
CLI · DuckDB
$ printf '%s\n' '021000021' '111000025' > column.txt
$ finetype infer -f column.txt --mode column
SELECT ft_profile(v) FROM (VALUES ('021000021'), ('111000025')) t(v);After 111000025, one type remains: aba_routing.