Commas in export data

Hi,

I've just started creating my first form, and I've noticed that if I include a comma in the field label, the csv export data gets all messed up. The question gets broken at the comma, but the responses keep filling every column in the csv file, so the responses end up in all the wrong columns. It would be great to have the columns separated by something other than a comma, or to somehow escape the question with quotation marks etc.

I've had a little look on the forums and it looks like the same thing can happen if users include commas in their responses? I'm only just starting out with Gravity Forms so I haven't come across this second problem yet, but I imagine it might be a similar cause/fix. I'm a little confused about the various conversations shared on the forums, so I'm just wondering if you can please share the best way to fix this? I'd rather not have to edit the plugin files, but happy to with a little guidance!

Thanks for your help.

Hi,

Thanks for the response, although I think I may need some more help here. I've copied and pasted the example code from your link, and now my csv data looks even more strange. It's still separating at the commas, but ONLY at the commas now. Other than the commas, the questions and results are all compressed in a single column, with the pipe and its quotation marks "|" displayed in the cell. Have I done something wrong? I've just copied and pasted the code exactly into functions.php. Happy to email you the csv file if it helps explain things.

Thanks.

OK so it works if I tell the program to use a pipe as the delimiter. My problem is that there are about six different admins who will all be exporting form data, and I know this will end up causing a lot of confusion. If I set the delimiter to a semicolon (or a tab, if that's possible?) rather than a pipe, do you know if Excel, OpenOffice Calc etc will recognise that by default, without having to change it in the program settings?

Thanks heaps.