EXAMPLE - IPTOINT Function

This examples illustrates how you can convert IP addresses to numeric values for purposes of comparison and sorting.

Functions:

Source:

Your dataset includes the following values for IP addresses:

Transformation:

When the above data is imported, the application initially types the column as URL values, due to the presence of the http:// and 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 http:// and https:// strings:

IpAddr

`http%?://`

''

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:

IpAddr

`1.2.3[end]`

'1.2.3.0'

true

All values in the column should be valid for the IP Address data type. To convert these values to their integer equivalents:

Single row formula

IPTOINT(IpAddr)

'ip_as_int'

You can now manipulate the data based on this numeric key. To convert the integer values back to IP addresses for checking purposes, use the following:

Single row formula

IPFROMINT(ip_as_int)

'ip_check'

Results: