Accomplishing this with ARS seems not trivial at all. If it can be accomplished, it will look messy and cludgy.
My knee jerk reaction would be to find a shell or perl script that can accomplish this and call that script with a set fields $PROCESS$ or filter API. The perl archive is the first place I would look in: http://www.cpan.org -Guillaume -----Original Message----- From: Action Request System discussion list(ARSList) on behalf of Nall, Roger Sent: Wed 03/18/09 4:42 PM To: arslist@ARSLIST.ORG Subject: OT: Format IP Address 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 _______________________________________________________________________________ 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"