|Date: ||Thu, 12 Apr 2007 06:51:43 -0700|
|Reply-To: ||Andrew H Karp <sfbay0001@AOL.COM>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||Andrew H Karp <sfbay0001@AOL.COM>|
|Subject: ||Re: Need a regular expression pattern for the Phone number data|
|Content-Type: ||text/plain; charset="iso-8859-1"|
Check out my the PDF of the presentation I gave at the last SUGI
conference (2006, in SF), called "Getting in to the PICTURE Format"
It is available for free download from my web site, http://www.sierrainformation.com
Click on the past presentations link to access PDFs of this and
several other presentations I've given at SAS user group events.
Sierra Information Services
On Apr 12, 5:38?am, SASL...@SAVIAN.NET (Alan Churchill) wrote:
> I am a bit confused. Of the record examples below, what part is the phone
> number? These do not look like US numbers so help me out a bit.
> Alan Churchill
> Savian "Bridging SAS and Microsoft Technologies"www.savian.net
> -----Original Message-----
> From: SAS(r) Discussion [mailto:S...@LISTSERV.UGA.EDU] On Behalf Of Get
> Sent: Wednesday, April 11, 2007 10:17 PM
> To: S...@LISTSERV.UGA.EDU
> Subject: Need a regular expression pattern for the Phone number data
> I have the following pattern of phone numbers in my input file.
> 8317593 / 63721630
> 8320616 / 62216684459
> 8320659 / 62216602710/3718
> 8331707 / 62806414/8415388
> I would like to match these numbers, and if matches then output to a
> variable say 'Phone no'.
> Since the input file holds records in multiple rows, the use of @
> makes these phones numbers into the customer name columns, leaving the
> phone number blank.
> i searched in the web, and cdn't find a similar example and moreover I
> have a / as a part of the data where we have /'s in the regEx patterns
> too. Little confused! :)
> Note : the customer name may be alpha-numeric too.
> Easwara- Hide quoted text -
> - Show quoted text -