If you have perl installed on the server, it can be easily accomplished on
the command line like this:
perl -e 'print join ".", map {sprintf "%03d", $_} split(/\./,
"13.23.3.33");'
Depending on your setup, you might have to put in the full path to perl to
get it to run in the set field $PROCESS$ command.
Juan Ingles
--
On Thu, Mar 19, 2009 at 6:43 AM, Guillaume Rheault <[email protected]>wrote:
> **
>
> 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: [email protected]
> 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"
>
> __Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
> html___
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
