CIDR Notation
Classless Inter-Domain Routing notation combining an IPv4 address with a prefix length (e.g., 192.168.1.0/24). Used in network configuration, firewall rules, and IP access control.
CIDR Notation
technology.internet.cidrClassless Inter-Domain Routing notation combining an IPv4 address with a prefix length (e.g., 192.168.1.0/24). Used in network configuration, firewall rules, and IP access control.
Domain
technology
Category
internet
Casts to
VARCHAR
Scope
Universal
Try it
CLI
$ finetype infer -i "192.168.1.0/24"
→ technology.internet.cidrDuckDB
Detect
SELECT finetype('192.168.1.0/24');
-- → 'technology.internet.cidr'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.cidr';Struct Expansion
Expression
network: REGEXP_EXTRACT({col}, '^([^/]+)/')
prefix_length: CAST(REGEXP_EXTRACT({col}, '/(\d+)$') AS TINYINT)JSON Schema
finetype schema technology.internet.cidr
{
"$id": "https://meridian.online/schemas/technology.internet.cidr",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"description": "Classless Inter-Domain Routing notation combining an IPv4 address with a prefix length (e.g., 192.168.1.0/24). Used in network configuration, firewall rules, and IP access control.",
"examples": [
"192.168.1.0/24",
"10.0.0.0/8",
"172.16.0.0/12",
"0.0.0.0/0"
],
"pattern": "^(?:(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\\.){3}(?: 25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)/([0-9]|[12]\\d|3[0-2])$",
"title": "CIDR Notation",
"type": "string",
"x-finetype-broad-type": "VARCHAR",
"x-finetype-transform": "CAST({col} AS VARCHAR)",
"x-finetype-transform-ext": "CAST({col} AS INET)"
}Examples
192.168.1.0/2410.0.0.0/8172.16.0.0/120.0.0.0/0Aliases
cidr_blockip_range