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
