RE: how to escape new lines using select * into outfile

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

So far as I've been able to figure out, there's no form of escaping that
will convince Excel to do what you want.

The only thing I can think of is to replace * with a list of fields, and use
MySQL functions to replace the \n with something else.

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com

>-----Original Message-----
>From: Saravanan [mailto:suzuki_babu@xxxxxxxxx]
>Sent: Tuesday, May 13, 2008 1:26 PM
>To: mysql
>Subject: how to escape new lines using select * into outfile
>
>Hi all,
>
>I want to export the values based on the condition. I export them as
>csv.
>
>select * into outfile 'filename.csv' from table;
>
>the problem is one field in table has many lines, means with \n. I
>couldn't import the values into the xls sheet.
>
>any ideas how to escape the new line characters?
>
>Thanks,
>Saravanan
>
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=jschwartz@the-
>infoshop.com





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx