Brian Dunning's FileMaker Custom Functions

CIDR2IPList_IPv4 ( cidr ; start )

Converts IPv4 CIDR notation into a list of IP addresses.

  Average rating: 4.3 (28 votes) Log in to vote

Maxwell Klein   Maxwell Klein
Maxwell Klein Consulting
http://www.maxwellklein.com

Share on Facebook Share on Twitter

  Sample input:
CIDR2IPList_IPv4 ( "192.168.1.0/30" ; 0 )

CIDR2IPList_IPv4 ( "10.0.1.128/29" ; 1 )
  Sample output:
"192.168.1.0¶192.168.1.1¶192.168.1.2¶192.168.1.3¶192.168.1.4"

"10.0.1.129¶10.0.1.130¶10.0.1.131¶10.0.1.132¶10.0.1.133¶10.0.1.134¶10.0.1.135¶10.0.1.136"

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Requires IP2IPLong and IPLong from Dick Impens. Because of FileMaker recursive limits, can only list prefix blocks between 32 and 19.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.