Page tree


Support | BlogContact Us | 844.332.2821

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r0411

D toc

Computes an integer value for a four-octet internet protocol (IP) address. Source value must be a valid IP address or a column reference to IP addresses.

IP addresses must be in the following format:

Code Block

where aaabbbccc, and ddd, are integers 0 - 255, inclusive.


NOTE: IPv6 addresses are not supported.

The formula used to compute the integer equivalent of the above IP address is the following:

(aaa * 2563) + (bbb * 2562) + (ccc * 256) + (ddd)


Output: Generates a column containing the integer value 16909060.

Column reference example:

D code

derive value: IPTOINT(IpAddr) as: 'ip_as_int'


  • Missing input values generate missing results.
  • Multiple columns and wildcards are not supported.

D s


Required?Data TypeExample Value
YesString literal or column reference (IP address)

D s

Example - Convert IP addresses to integers