Australian Business Number
11-digit identifier for Australian businesses, issued by the Australian Business Register. May appear with or without spaces.
Australian Business Number
identity.government.abn11-digit identifier for Australian businesses, issued by the Australian Business Register. May appear with or without spaces.
Domain
identity
Category
government
Casts to
VARCHAR
Scope
Locale-specific
Locales
EN_AU
Try it
CLI
$ finetype infer -i "51 824 753 556" --mode column
→ identity.government.abnDuckDB
Detect
SELECT ft_infer('51 824 753 556');
-- → 'identity.government.abn'Cast expression
CAST({col} AS VARCHAR)Safe cast pipeline
-- Normalise and cast in one step
SELECT TRY_CAST(ft_cast(my_column) AS VARCHAR) AS clean_value
FROM my_table
WHERE ft_infer(my_column) = 'identity.government.abn';JSON Schema
finetype taxonomy identity.government.abn -o json-schema
{
"$id": "https://meridian.online/schemas/identity.government.abn",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "11-digit identifier for Australian businesses, issued by the Australian Business Register. May appear with or without spaces.",
"examples": [
"51 824 753 556",
"53004085616",
"12 345 678 901",
"98 765 432 109"
],
"maxLength": 14,
"minLength": 11,
"pattern": "^\\d{2}\\s?\\d{3}\\s?\\d{3}\\s?\\d{3}$",
"title": "Australian Business Number",
"type": "string",
"x-finetype-label": "identity.government.abn",
"x-finetype-pii": false
}Examples
51 824 753 5565300408561612 345 678 90198 765 432 109Aliases
australian_business_number