New IP functions in APL

We’re excited to announce that we have added seven new IP functions to Axiom Processing Language (APL).

• has_any_ipv4 checks whether a field contains any IPv4 addresses from a specified set of IPv4 addresses.
• has_any_ipv4_prefix checks if an IPv4 address starts with any prefix in a list of specified prefixes.
• has_ipv4 checks if an IPv4 address appears in a specified text.
• has_ipv4_prefix checks if an IPv4 address starts with a specified prefix.
• ipv4_compare compares two IPv4 addresses.
• ipv4_is_in_any_range checks whether an IPv4 address belongs to any range of IPv4 subnets.
• ipv4_is_match checks whether an IPv4 address matches an IPv4 pattern.

We have also added the percentileif aggregation function. It calculates the requested percentiles of a field for the rows where a condition evaluates to true.

For more information, see the documentation.