Roger, i would accomplish this with a set field SQL.
SELECT LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\1'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\2'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\3'),3,'0')||'.'|| LPAD(regexp_replace(ip,'(\d*)\.(\d*)\.(\d*)\.(\d*)','\4'),3,'0') FROM (SELECT '10.38.190.9' AS ip FROM dual) All you have to do is replace '10.38.190.9' with '$your_ip_field_name$' HTH Kind Regards Conny -----Ursprüngliche Nachricht----- Von: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] Im Auftrag von Nall, Roger Gesendet: Mittwoch, 18. März 2009 22:02 An: arslist@ARSLIST.ORG Betreff: Re: OT: Format IP Address Ravi, The idea is to do this as the data is being processed. We need to do this essentially after the user enters the IP address. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile, USA Desk:972-464-3712 NEW Cell: 973-652-6723 FAX: sf49fanv AIM IM RogerNall Yahoo IM -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ravi Sent: Wednesday, March 18, 2009 3:58 PM To: arslist@ARSLIST.ORG Subject: Re: OT: Format IP Address If you are looking to perform this for a large set of records, you could use ARS APIs (java or perl) to grab each record, modify the value within your script and update the record in Remedy. Nall, Roger wrote: > ** > > All, > > > > ARS 7.01 p4 > > Oracle 10g > > Solaris 9 > > > > We have a request to format data that is stored in a character field. > The data is standard IP addresses: xx.x.xx.xxx The idea is to make > each octet three characters by padding zeros. So the previous example > would look like: 0xx.00x.0xx.xxx. We are wondering if anyone has any > suggestions for doing this when the data is stored in one field. > > > > Thanks, > > > > Roger A. Nall > Manager, OSSNMS Remedy > T-Mobile, USA > Desk:972-464-3712 NEW > > Cell: 973-652-6723 > FAX: > sf49fanv AIM IM > RogerNall Yahoo IM > > > > __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" > html___ -- Thank you, RaVi ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
