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:[EMAIL PROTECTED] >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/[EMAIL PROTECTED] >infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
