Re: extracting data from table embedded in Word document

2004-03-21 Thread Andrew Gaffney
R. Joseph Newton wrote: Andrew Gaffney wrote: The above code won't work because it splits on a comma. A lot of the fields contain a comma somewhere within the actual data. If it was easy as that, I would have had this done long ago ;) -- Andrew Gaffney Hi Andrew, Don't count on it not being

Re: extracting data from table embedded in Word document

2004-03-21 Thread R. Joseph Newton
Andrew Gaffney wrote: > > The above code won't work because it splits on a comma. A lot of the fields contain a > comma somewhere within the actual data. If it was easy as that, I would have had > this done > long ago ;) > > -- > Andrew Gaffney Hi Andrew, Don't count on it not being that easy.

Re: extracting data from table embedded in Word document

2004-03-21 Thread Andrew Gaffney
Charles K. Clarkson wrote: Andrew Gaffney <[EMAIL PROTECTED]> wrtoe: : : I managed to get Word to export it into a format where : the fields are separated by '\r'. Yeah, kinda weird. I : wrote the following: : : open FILE, $file; : my $counter = 0; : : while () { :while (/\r?([^\r]*)/sgc) {

RE: extracting data from table embedded in Word document

2004-03-21 Thread Charles K. Clarkson
Andrew Gaffney <[EMAIL PROTECTED]> wrtoe: : : I managed to get Word to export it into a format where : the fields are separated by '\r'. Yeah, kinda weird. I : wrote the following: : : open FILE, $file; : my $counter = 0; : : while () { :while (/\r?([^\r]*)/sgc) { : $counter++; : i

Re: extracting data from table embedded in Word document

2004-03-21 Thread Ralf Schaa
Andrew Gaffney wrote: 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

Re: extracting data from table embedded in Word document

2004-03-20 Thread Andrew Gaffney
Andrew Gaffney wrote: 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 t

Re: extracting data from table embedded in Word document

2004-03-20 Thread Andrew Gaffney
R. Joseph Newton wrote: Andrew Gaffney wrote: I'm writing a web-based client information system for a lawyer. [OT} Eek!! Be very, very careful about security, please. I trust your employer has taken "duty of care" isuues into account. [/OT] His current client list is in a 137 page Word docu

Re: extracting data from table embedded in Word document

2004-03-20 Thread R. Joseph Newton
Andrew Gaffney wrote: > I'm writing a web-based client information system for a lawyer. [OT} Eek!! Be very, very careful about security, please. I trust your employer has taken "duty of care" isuues into account. [/OT] > His current client list is > in a 137 page Word document with an embedde

RE: extracting data from table embedded in Word document

2004-03-20 Thread Charles K. Clarkson
Andrew Gaffney <[EMAIL PROTECTED]> wrote: : : 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: : [snip] : : So it looks like 3 records instead of 2. Does anyone : ha

extracting data from table embedded in Word document

2004-03-20 Thread 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.