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"
