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
: have any ideas on how to pick apart the data to get
: it into the DB?
How about replacing the newlines in a copy of the
Word file. Swap them for something that is not in the
table, like "~~~". Then add them back as you read the
records into your database.
HTH,
Charles K. Clarkson
--
Mobile Homes Specialist
254 968-8328
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
