how to escape new lines using select * into outfile

[Database Administrator]

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

[Database Administrator]

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@yahoo.com]
>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

[Database Administrator]

Try using:

select * into outfile 'filename.csv' fields enclosed by '"' terminated by
',' lines terminated by '\n' from table

Regards,

Velen


----- Original Message -----
From: "Saravanan"
To: "mysql"
Sent: Tuesday, May 13, 2008 9:26 PM
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=velen@biz-mu.com
>
>

[Database Administrator]

thanks velen. But I want to escape the newlines in the fields. It is annoying and new lines moves the values in separate line of excel sheet.

Thanks,
Saravanan


--- On Wed, 5/14/08, Velen wrote:

> From: Velen
> Subject: Re: how to escape new lines using select * into outfile
> To: suzuki_babu@yahoo.com
> Cc: mysql@lists.mysql.com
> Date: Wednesday, May 14, 2008, 1:35 AM
> Try using:
>
> select * into outfile 'filename.csv' fields
> enclosed by '"' terminated by
> ',' lines terminated by '\n' from table
>
> Regards,
>
> Velen
>
>
> ----- Original Message -----
> From: "Saravanan"
> To: "mysql"
> Sent: Tuesday, May 13, 2008 9:26 PM
> 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=velen@biz-mu.com
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=s...babu@yahoo.com

[klk26klk26]

Saravanan,

Did you find a way to do this, I too am trying to export data from mySQL into excel and continue to get new line characters where they shouldn't be.

Thanks!