Registered users of this product or Trifacta Wrangler Enterprise should login to Product Docs through the application.
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:
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)
As a result, each valid IP address has a unique integer equivalent.
Numeric literal example:
Output: Generates a column containing the integer value 16909060.
Column reference example:
Output: Generates the new ip_as_int column containing the value of the
IpAddr column converted to an integer value.
|column_ipaddr||Y||string||Column name or string literal identifying the IP address to convert to an integer value|
For more information on syntax standards, see Language Documentation Syntax Notes.
Name of the column or IP address literal whose values are used to compute the equivalent integer value.
- Missing input values generate missing results.
- Multiple columns and wildcards are not supported.
|Required?||Data Type||Example Value|
|Yes||String literal or column reference (IP address)|
Example - Convert IP addresses to integers
This examples illustrates how you can convert IP addresses to numeric values for purposes of comparison and sorting. This example illustrates the following functions:
IPTOINT- converts an IP address to an integer value according to a formula. See IPTOINT Function.
IPFROMINT- converts an integer value back to an IP address according to formula. See IPFROMINT Function.
Your dataset includes the following values for IP addresses:
When the above data is imported, the application initially types the column as URL values, due to the presence of the
https:// protocol identifiers. Select the IP Address data type for the column. The last three values are listed as mismatched values. You can fix the issues with the last two entries by applying the following transform, which matches on both
%? Trifacta® pattern matches zero or one time on any character, which enables the matching on both variants of the protocol identifier.
Now, only the
1.2.3 value is mismatched. Perhaps you know that there is a missing zero at the end of it. To add it back, you can do the following:
This page has no comments.