Email Form CSV file uses semicolons and not commas
Author: Gabriel C.
Visited 954,
Followers 2,
Shared 0
Hello. When using the email form object, the CSV file uses ; as a separator and does not have obvious option to change to comma. This would be extremely helpful as Excel automatically separates columns based on commas and requires manual adjustments when the semicolon is used.
Posted on the
Author
Sorry, I meant to post this as a question, not an idea.
Hello Gabriel,
The CSV files generated by the program use always as separator the semicolon.
When importing a csv file in excel you have the option to choose the semicolon as separator instead of comma.
Many thanks!
Author
Thanks, but I know that you can manually make this change in excel. Consider that if commas are used then excel does it automatcally. It is one less series of steps that you have to try to explain to someone trying to view the file. Besides that, CSV stands for Comma Separated Values and not for semi-Colon Separated Values.
Hello Gabriel,
If it would be comma separated then it would not longer be possible to use the comma as example in the product description since it would be a delimiter.
Many thanks!