Wildcard deletion

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to get an email list out of this file below(the below file is actually 6 pages long)… i.e., each instructors name followed by “@sln.suny.eduâ€

So for example (e-mail address removed), (e-mail address removed), etc.,etc.,etc
I want to delete everything but the email address and the university/college name located to the right of the nam

I can’t figure it out. Could anyone please help me. Thank you in advance it is greatly appreciated

(212034) Business Mathematics (01/12/2004-04/23/2004): Susan Webber (SUNY Empire State College) (271104) Algebra (01/12/2004-04/23/2004): Marj Robison (SUNY Empire State College) (271104) Algebra (SL2) (01/12/2004-04/23/2004): Leighann Nastasia (SUNY Empire State College) (MTH165-SL2) College Algebra (SL2) (09/02/2003-12/18/2003): Donna Petrie (Monroe Community College) (MTH175-SL1) Pre Cal Anl Geo (09/02/2003-12/18/2003): Jannette Avery (Monroe Community College) (SX017-OLB) Retail Math:Merchandise Planning and Gross Margin (SL2) (11/03/2003-12/13/2003) (Postponed This Term): Deborah Friedman (Fashion Institute of Technology
 
A response was posted to your almost identical request of March 12. Is that
not what you want?

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Fellow MVP Doug Robbins replied to this on the 15th March -
http://groups.google.co.uk/groups?q...=#[email protected]&rnum=1

However there are a couple of provisos with the search string he suggested.
First of all this can only be done if all the people have the same ISP
address. The list suggests several colleges or departments. ie the e-mail
addresses will all end in @sln.suny.edu. If some of them have different
suffixes, this is going to be impossible to work out (in a single pass) as
there is no unique
search pattern. You would need to account for every possible string and
there are some different ones in just the sample provided - so given that
what you want is a list that looks like:

(e-mail address removed)
(e-mail address removed)
etc (I have changed the suffix in case these are real addresses to try and
avoid the attention of spammers) then search for

*: ([A-z]{1,}) ([A-z]{1,})

and replace with

\1.\[email protected]^p

Paste the lines from here into the replace tool.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP

Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 
Back
Top