MAC Address
Type Registry
MAC Address
technology.internet.mac_address Media Access Control (MAC) address in standard colon-separated hex format (e.g., 00:1a:2b:3c:4d:5e). Also accepts hyphen-separated format.
Domain technology›internet
Casts to VARCHAR
Scope Universal
Try it
CLI
$ finetype infer -i "00:1a:2b:3c:4d:5e"
→ technology.internet.mac_address DuckDB
Detect
SELECT finetype('00:1a:2b:3c:4d:5e');
-- → 'technology.internet.mac_address' Cast expression
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) = 'technology.internet.mac_address'; JSON Schema
finetype schema technology.internet.mac_address {
"$id": "https://noon.sh/schemas/technology.internet.mac_address",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Media Access Control (MAC) address in standard colon-separated hex format (e.g., 00: 1a: 2b: 3c: 4d: 5e). Also accepts hyphen-separated format.",
"examples": [
"00: 1a: 2b: 3c: 4d: 5e",
"08-00-27-00-00-00",
"a0:b1:c2:d3:e4:f5"
],
"pattern": "^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$",
"title": "MAC Address",
"type": "string"
} Examples
00:1a:2b:3c:4d:5e08-00-27-00-00-00a0:b1:c2:d3:e4:f5 Also known as
mac