I'm wondering if I'm the only one with this problem.
I've been using and heavily relying on exporting/importing between phpMyAdmin and CSV for years and years.
Recently, phpMyAdmin was upgraded (both via CPanel and I even downloaded and installed phpMyAdmin myself).
The "CSV" and "CSV to Excel" exports no longer work properly. The saved file has this problem when read in Notepad so it's not Excel.
The titles are semicolon delimited in "CSV for MS Excel".
Exporting plain "CSV", the field names are comma delimited when I designate using a comma.
Exporting both ways, the content of certain cells are not contained within the proper delimited character which should be a comma.
Wherever there is a comma in the content of one field, Excel 2010 sees that as a separate cell using that comma as a delimiter, sorta.
The db is mySQL UTF-8.
E.g., an excerpt of a field is
This is what I get when exporting as CSV for MS Excel. (CSV exports as comma delimited, Columns enclosed with a double quote, Columns escaped with [blank] have commas as the field name separators).Code:and a small, woven, heat-sealed U.S. Flag .75" tall X 1.4" wide, stars forward on the right side of the cap.
The output is split into two cells where the comma was.
Notice the missing quote after .75
If I escape the columns with a backslash, I get the following still split into two cells.Code:and a small, woven, heat-sealed U.S. Flag .75 tall X 1.4" wide stars forward on the right side of the cap.
Any help getting over this is appreciated.Code:and a small, woven, heat-sealed U.S. Flag .75\ tall X 1.4\" wide stars forward on the right side of the cap.
Submit Your Article
Forum Rules

Reply With Quote
