Date:         Thu, 30 Oct 2003 16:54:39 +0100
Reply-To:     "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Groeneveld, Jim" <jim.groeneveld@VITATRON.COM>
Subject:      Re: Parsing Multiple Email Addresses
Comments: To: Catherine Ward <cberzins2003@YAHOO.COM>
Content-Type: text/plain; charset="iso-8859-1"

Dear Cathy,

Use the SCAN function with " /," as the list of delimiters, though that would not seem sufficient here.

Regards - Jim.
--
.  .  .  .  .  .  .  .  .  .  .  .  .  .  .  .

Jim Groeneveld, MSc.
Biostatistician
Science Team
Vitatron B.V.
Meander 1051
6825 MJ  Arnhem
Tel: +31/0 26 376 7365
Fax: +31/0 26 376 7305
Jim.Groeneveld@Vitatron.com
www.vitatron.com

My computer has the solutions, I have the problems.

[common disclaimer]


-----Original Message-----
From: Catherine Ward [mailto:cberzins2003@YAHOO.COM]
Sent: Thursday, October 30, 2003 16:42
To: SAS-L@LISTSERV.UGA.EDU
Subject: Parsing Multiple Email Addresses


It's been a while since I've been on the listserv, so if this has been covered, I apologize!

Does anyone have a suggestion for parsing/extracting multiple email addresses from a text field?  Examples of the data have been entered include:
Name@MSN.COM  Name@NC.RR.COM
Name@NCOL.NET...Name@ncol.net
name@msn.com, name@msn.com
name@aol.com//name2022@nc.rr.com
name@peoplepc.com/name.1@netzero.net
name@BASF-CORP.COM or name20@msn.com
name's@cs.com  name-name.place@btitelecom.net

Thanks in advance!

Cathy


---------------------------------
Do you Yahoo!?
Exclusive Video Premiere - Britney Spears