Re: Trimming IP Addresses

From: Jim Kennedy <jim>
Date: Thu, 8 Jun 2006 07:32:07 -0700
Message-ID: <qc2dnXOs95baqRXZnZ2dnUVZ_rydnZ2d@comcast.com>

"jhulst" <josh.hulst_at_gmail.com> wrote in message news:1149776645.026569.240750_at_h76g2000cwa.googlegroups.com...
> Hello,
> I am looking for a function that will allow me to trim off the right
> octet of an ip address. ie. go from 192.168.1.255 to 192.168.1
> I tried using a rtrim function using a wildcard such as
> rtrim(ipaddress, '.%') but it doesn't give me anything. Any help or
> advice would be much appreciated.
>
> Thanks,
> Josh
>

rtrim trims trailing characters from a string. Use a combination of instr and substr. See the docs.
Jim Received on Thu Jun 08 2006 - 09:32:07 CDT