Page tree

 

Support | BlogContact Us | 844.332.2821

Versions Compared

Key

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

D toc
 
Excerpt

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
aaa.bbb.ccc.ddd

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

Info

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
snippetusage

 

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

D s
snippetExamples

Example - Convert IP addresses to integers

...