Using Word to strip out code from text document

[Matthew Ingram]

Hi,

I'm trying to use the find and replace feature in word to strip out unwanted code from a long list of emails i'm putting together for my website's mailing list.

For instance I have a list of emails like this:

Sam<sam@msn.com>

Lulu<lulu@google.com>

etc

and I need to generate one like this:

sam@msn.com

lulu@google.com

Does anyone know how I might achieve this?

Thanks in advance

Matthew

[uid0]

Word isn't the ideal tool for the job, if the list is plain text I'd try gsar

http://gnuwin32.sourceforge.net/packages/gsar.htm

or you could use excel, splitting the columns on the < and > during import

[jaclaz]

Actually for such tasks Word can do it:

1) run search and replace with search "<" and replace "^t" (without quotes), this will replace every occurrence of < with a TAB

2) run search and replace with search ">" and replace "" (i.e. have the replace box empty), this will replace every occurence of > with nothing.

3) Select the list and use "Convert text to table" making sure to use TAB as the delimiter.

4) either delete the column before the e-mail addresses and convert the table back to text or select only the column with e-mails and paste it in another document (either Word or, as suggested, Excel)

Alternatively, you can save the Word file to "plaintext" with a .csv extension and then use Excel as uid0 suggested.

jaclaz