CIDR_MATCH
Description
CIDR_MATCH
is a row function that compares two TEXT
arguments representing a CIDR mask and an IP address, and returns 1
if the IP address falls within the specified subnet mask or 0
if it does not.Syntax
CIDR_MATCH
(CIDR_string
, IP_string
)Return Value
Returns an
INTEGER
value of 1
if the IP address falls within the subnet indicated by the CIDR mask and 0
if it does not.Input Parameters
- CIDR_string
- Required. A field or expression that returns aTEXTvalue containing either an IPv4 or IPv6 CIDR mask (Classless InterDomain Routing subnet notation). An IPv4 CIDR mask can only successfully match IPv4 addresses, and an IPv6 CIDR mask can only successfully match IPv6 addresses.
- IP_string
- Required. A field or expression that returns aTEXTvalue containing either an IPv4 or IPv6 internet protocol (IP) address.
Examples
Compare an IPv4 CIDR subnet mask to an IPv4 IP address:
CIDR_MATCH("60.145.56.0/24", "60.145.56.246") returns
1
CIDR_MATCH("60.145.56.0/30", "60.145.56.246") returns
0
Compare an IPv6 CIDR subnet mask to an IPv6 IP address:
CIDR_MATCH("fe80::/70", "FE80::0202:B3FF:FE1E:8329") returns
1
CIDR_MATCH("fe80::/72", "FE80::0202:B3FF:FE1E:8329") returns
0