Is there any easy way to change CSV delimiter to semicolon instead of comma?
When using locales where comma is used as a decimal separator, Excel does not import CSVs with multline text fields correctly. Instead of writing every line inside a single cell, Excel separates them to multiple cells and messes whole table structure. When using semicolon as a CSV delimiter, it works fine.
dennis@oatmeal.nl
Member
I just figured out a hack because I had the same problem.
What I did is strip the newline out of the values and replace them with some spaces. It works for me with excel 2003.
look for the file export.php in the folder gravityforms.
arround line 492
change:
$lines .= '"' . str_replace('"', '""', $value) . '",';into:
$strippedValue = preg_replace('/\r\n/', ' ', $value) ;
$lines .= '"' . str_replace('"', '""', $strippedValue) . '",';good luck
Currently there is no hook for this, but I have added it to our to do list for the next major feature release.
