If 'text' is stored in the HTML format in the db, the only solution I can
think of is writing a perl/shell script to parse out the <br> and recreate
the files without it, that ways, the data in the DB is not disturbed and
Excel should be able to read it to (unless someone knows of a setting in
Excel which will make it ignore <br>)

Regards,
Bhavin.
----- Original Message -----
From: "Walter D. Funk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 2:34 PM
Subject: Mysql : Problems to make a file dump /n and <br>


> Hi,
>
> I'm making a CSV from a Mysql table, in which text is stored as is, with
all
> <br> to keep format etc (I need to keep line breaks because the same text
> has to be printed out in a page taking care of the original fomatting);
>
> The problem comes actually when Excell tries to read the CSV (; separates
> columns and ;; is a new row) all <br> inside the text  are parsed as a
> Carriage return causing Excel to display a new Row in the middle of a text
> field;
> I've been looking up the mysql manual but I couldn't find a workaround for
> this,
> can someone help me, please?
>
> thanks in advance to everybody
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to