I needed to convert some numerical IP addresses to a human understandable form the other day. After writing a Groovy script to do this, I found a simpler way; use built in database functions. For example, MySQL has the function INET_NTOA() to convert IP addresses from numerical to dotted form. It is called using a select statement like this.
select INET_NTOA('123456789') as ipaddress;
This returns the value '7.91.205.21' and can be called using the "Read Database" operator.
Obviously, you would use parameters to construct the query in the general case and a loop would be needed to iterate over multiple examples. Performance might be slow for large data sets.
Search this blog
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment