When I export a CSV file on my local development website (a wamp setup) and open it in Excel everything looks fine. But when I do the same thing on the live website the CSV file opened in Excel ends up with the field delimiters escaped. For example:
on my local web one entry in the Name column looks like this:
but then that same Name column generated by the live website (on a different web hosting provider) looks like this:
Since the big difference between the two files is the server they were generated on I'm guessing there may be some sort of server-side setting that can (hopefully) be changed to remove the extra escaping.
Can anyone point me in the right direction?