Re: Parsing a phone number

From: Alan <alanshein_at_spambuster.erols.com>
Date: Thu, 16 Nov 2000 16:04:28 -0500
Message-ID: <8v1i4c$b1l$1@bob.news.rcn.net>

There are several ways to do this. How many rows?

<steveee_ca_at_my-deja.com> wrote in message news:8v1f4g$ufi$1_at_nnrp1.deja.com...
> Hi everyone,
>
> I've just been asked to create a script that will go through a field of
> phone numbers that have been stored 'free form' (e.g. (614) 222-3333,
> 614-222-3333, 222-3333 etc) and strip out all of the punctuation and
> spaces
> so that only the numerals are stored (i.e. 6142223333).
>
> This is a one time only thing so I don't have to be too worried about
> performance..we'll run it at 2 am if we have to :)
>
> Any help would be deeply appreciated..
>
> Oracle 8.0 , Sun Solaris 2.6
>
> Thanx in advance,
>
> Steve
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 16 2000 - 15:04:28 CST