Parsing a phone number

From: <steveee_ca_at_my-deja.com>
Date: Thu, 16 Nov 2000 20:13:13 GMT
Message-ID: <8v1f4g$ufi$1@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 - 14:13:13 CST