How do I parse out email addresses using find/replace?

G

geekseeker

After copying a distribution list from an email, I have a list of email
addresses in the form of "Sam"<[email protected]> including the quotes around
Sam and the <> around the email address. I would like to end up with a list
of just the email addresses, e.g. (e-mail address removed). I can do this in Excel,
but would like to learn how to do it in Word.
 
J

Jay Freedman

After copying a distribution list from an email, I have a list of email
addresses in the form of "Sam"<[email protected]> including the quotes around
Sam and the <> around the email address. I would like to end up with a list
of just the email addresses, e.g. (e-mail address removed). I can do this in Excel,
but would like to learn how to do it in Word.

The key to this is using wildcard find/replace
(http://www.gmayor.com/replace_using_wildcards.htm).

This find expression:

*\<([! ]@)(\@)(*)\>*^13

and this replace expression:

\1\2\3^p

should do the job.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top