mySQL Exporting

[inveni0]

I've never had this problem before! I'm trying to export one of my tables to CSV. No matter how I change the field separator, when importing to Excel, it terminates the lines at the wrong place. I can't figure out why. Is there another line terminator that could be present in my table? Like </ br>?

I forgot to ad that I'm using phpMyAdmin

[coopster]

I believe phpMyAdmin has a "CSV" option during export as well as a "CSV for Excel" or something like that. It likely has to do with inserting the correct line endings for use in Excel. Have you looked at those options?

[inveni0]

Actually, it turns out that it was reading some line breaks (<br>) as field terminations. I had to revist those records and remove the line breaks....boring....

[txbakers]

I wish that mySQL or the exporter would not read those. that's such a pain. it caught me as well.