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.

Thanks,

Andrew Karp Sierra Information Services www.SierraInformation.com

On Apr 12, 5:38?am, SASL...@SAVIAN.NET (Alan Churchill) wrote: > Easwara, > > 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 > > 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 > > Hi > > 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. > > Thanks > Easwara- Hide quoted text - > > - Show quoted text -