CSV export problem when data contains commas

gauravmak

Hey, this may sound weird but I am really facing this.
When I export the table data with CSV export option, cells with comma get broken into multiple pieces and those pieces occupy multiple cells.

This may seem to be normal and that's what CSV is meant for but this does not when I create CSV with php functions (fputcsv)
So, it may be fundamentally possible. Can Datatables do anything for this?

Take a note that, I need CSV only. TSV wont be feasible for me.

benjaminbaldoni

Hi, I had the same issue, check this: http://www.datatables.net/forums/discussion/29709/unexpected-csvhtml5-export-behavior

gauravmak

Thank you @benjaminbaldoni
Have a great day.