A new knowledge base article has been published on our support portal.
Scenario Overview
This is a bit of a strange business requirement but a customer was storing IP addresses in there CRM system & they needed to create a view which sorted the IP Addresses.We decided the easiest way was to pad the IP Address with zeros & place the result into a new field so we could sort on that field.
So in the example below we can see the following transformation,
9.45.4.255 -> 009.045.004.255