extracting data from table embedded in Word document

[Andrew Gaffney]

I'm writing a web-based client information system for a lawyer. His current client list is 
in a 137 page Word document with an embedded table. I can get it into a somewhat usable 
format by copying the entire table, pasting into Excel, and saving as tab delimeted text, 
but this has its problems.

Some of the cells in the table have newlines in them. Because of this, when it's exported 
from Excel, the 2nd line will appear in the correct field, but on a line by itself:

Row 1   Firstname       Lastname        Address City    State   Zip     Phone   
                                                                        AnotherPhone
Row 2   First2          Last            addy    City    State   Zip     555-5555
So it looks like 3 records instead of 2. Does anyone have any ideas on how to pick apart 
the data to get it into the DB?

--
Andrew Gaffney
Network Administrator
Skyline Aeronautics, LLC.
636-357-1548
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>