Exporting csv via phpmyadmin giving out mis-arranged data?

Up vote 0 down vote favorite share g+ share fb share tw.

I'm trying to export a csv file via phpmyadmin, below are the option I'm selecting, Fields terminated by , Fields enclosed by " Fields escaped by \ Lines terminated by AUTO Replace NULL by NULL Yet when I export the file, if the field contains a comma, the data shifts to the next column cell. Php mysql csv phpmyadmin link|improve this question edited Nov 2 '10 at 15:41Adnan4,51831234 asked Nov 2 '10 at 15:40texpert977 74% accept rate.

This issue is not unique to phpMyAdmin. Can you export in another format (ie: tab-delimited) – Brian Driscoll Nov 2 '10 at 15:46 Can you provide a sample of the rows that gets exported incorrectly? Or is this a problem with importing somewhere else?

– thetaiko Nov 2 '10 at 15:52 I'm guessing this has more to do with the file that is importing than the file that is exporting; is this happening with Excel? Have you tried using OpenOffice.org Calc (since it has a semi-interactive CSV import dialog) to open the file, and then export it to another format? – Dereleased Nov 2 '10 at 15:55 If it Excel that you're attempting to import into, set Fields escaped by character " – thetaiko Nov 2 '10 at 15:56 you all are right, it was all about how the .

Csv file scans and displays the data, cuz when I opened up that file as a tab delimited, and as .xlsx..... it showed me the data in a proper format.. but I would still like to know.... how can we make the file show in a proper format with csv..... if anyone knows.. – texpert Nov 2 '10 at 16:21.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.