Brian Dunning's FileMaker Custom Functions

IPLong ( number )

Creates a real IP address of an IP long number

  Average rating: 3.8 (41 votes) Log in to vote

Dick Impens   Dick Impens

Share on Facebook Share on Twitter

  Sample input:
IPLong ( 1249726302 )
  Sample output:

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

Converts a IP Long number to a real usable IP address.

This is used by a lot of php/mysql programmers as a IP Long number uses less space in the database, being a number (int) instead of a text (varchar).
Indexing is faster.

This function converts the number (int) back to a real IP addres, that can be used on the web or servers.



Michael Fuselier   Michael Fuselier, Sulphur, LA
Sep 29, 2013
Thanks, this may be just what I need.

Is there one to do the opposite, just in case I need to go back from an IP to an integer?

Dick Impens   Dick Impens, MaltaCode
Sep 30, 2013
Just posted a new function IP2IPLong.
Will showup here as soon as it is approved.

Log in to post comments.


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

Under construction. Email me your wish list for improvements.