[[email protected]]

2-1-08

Hi,

I received a WORD 2003 document consisting of 500 + names, address and phone
numbers typed as:

First MI Last †’ Home: 213-456-7890 (return)
123 Main St †’ Work: 213-789-0456 (return)
City, ST ZIP †’ Email: me@mydomain ¶


How do I parse the three lines of information into one line per record in
the following format:

First MI Last Street Address City ST ZIP Home # Work #
Email

so I can convert the text to a table and then into a usable data file.


Thanks so much for your help.

Joanne