Date:         Thu, 30 Oct 2003 08:13:15 -0800
Reply-To:     Catherine Ward <cberzins2003@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Catherine Ward <cberzins2003@YAHOO.COM>
Subject:      Re: Parsing Multiple Email Addresses
Comments: To: "Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM>
In-Reply-To:  <F0161D3F7AC5D411A5BE009027E774D60E61C4B0@gemmrd-scc013eu.gem.cibc.com>
Content-Type: text/plain; charset=us-ascii

This does get me going!  Thanks so much.   The clean up will be the easy part.

Kind regards,
Cathy

"Droogendyk, Harry" <Harry.Droogendyk@CIBC.COM> wrote:
use the translate / tranwrd functions to ensure the delimiting character is
space, then use scan to rip it apart. Some clean up remains but this is
enough to get you going.

data addresses (drop = _: );
length email_addr $100;
_a = "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";
_a = translate(_a,' ','/,');
_a = compbl(tranwrd(_a,'..',' '));
put _a=;
do until(0);
_i + 1;
email_addr = scan(_a,_i,' ');
if missing(email_addr) then leave;
if index(email_addr,'@') then output;
end;
run;

proc print;
run;

The SAS System 09:27 Thursday, October 30, 2003 13

Obs email_addr

1 Name@MSN.COM
2 Name@NC.RR.COM
3 Name@NCOL.NET
4 .Name@ncol.net
5 name@msn.com
6 name@msn.com
7 name@aol.com
8 name2022@nc.rr.com
9 name@peoplepc.com
10 name.1@netzero.net
11 name@BASF-CORP.COM
12 name20@msn.com
13 name's@cs.com
14 name-name.place@btitelecom.net

15
-----Original Message-----
From: Catherine Ward [mailto:cberzins2003@YAHOO.COM]
Sent: October 30, 2003 10:42 AM
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

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