I am not sure if I understand the issue - could you please provide us a .csv file to test it? It does not sound like a LS problem but more of a third-party spreadsheet software issue.

Seems clear : we surely don't use https://www.php.net/manual/en/function.fputcsv.php

@phitho ; can you confirm the way to reproduce

1. Add firstname "jean,jacque'
2. Add name "name'
   Export CS
   Loo at file :
   name,jean,jacque

@denischenu: Yes, that's the problem. What would be needed is to either put the different answers in quotation marks to mark them as text or to be able to select a separator. Thanks!

@cdorin : clear enough ?
@phitho : please, if you can add a screenshot of data, and a partial exported bad csv file.

I see - will mark it as confirmed and see the easiest solution to implement it

Attached you find a sample file.

participant_id,firstname,lastname,email,language,blacklisted,owner_uid,date,birthyear,gender,state,inhabtitant,education1,education2,municipality,city,btw2017recall,eu2019recall,education3,edu_school,edu_job,vote_intention_local,school
a2d4242b-0e86-4815-a28d-8385cfd3bd09,,,qqq@qqq.qq,en,N,69,,1991,Männlich,Nordrhein-Westfalen,,,,,Dortmund, krfr. Stadt,Sonstiges,Die Linke,,Abitur, EOS - Erweiterte Oberschule mit Abschluss 12. Klasse, Fachhochschulreife,Sonstiges,Die Linke,
cf40ae7a-b323-4ee2-976d-238b4bbbcb5e,,,qqq@qqq.qq,en,N,69,,1957,Weiblich,Nordrhein-Westfalen,,,,,Bielefeld, krfr. Stadt,Grüne,Grüne,,Abgeschlossenes Studium an Hoch- oder Fachhochschule, Universität, Polytechnikum,,Grüne,

So, I would choose to have a CSV field separator option in the pop up displayed on the screen when you confirm which columns are being selected. Separators to be used: Comma, Semicolon, Tab .

That should work! It could be problematic if someone imports open end answers where users may have entered e.g. tab in their answers, but for standard questions, that should work.

@cdorin : NO ! please , real csv : https://www.php.net/manual/en/function.fputcsv.php

enclosure.
This allow
abcde,123,"tot,titi","toto,\"titi"

It's the way PHP do with fputcsv, why create bad code when PHP have a great function ?

You can still allow update separator (dor some broken tools)

But : still use enclosure AND escape_char (default is OK with good tools and bad tools)

Yep, sounds cleaner. I will create a ticket in that regard

@gabrieljenik, could you please push the fix to LS4 as well when there is time?

Created a ticket for the enhancement: 16683
Created a ticket for LS4: 16672

@gabrieljenik great :+1:

PR: https://github.com/LimeSurvey/LimeSurvey/pull/1599
Used 'fputcsv' in CPDBExport() with default args

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=30506

Fixed in Release 3.23.6+200929

Hello everyone,
our admin installed the latest version, but still, it's not possible to select a separator for export. I only see this for import.
I understood that this should have been fixed in the latest release - or does our admin need to alter the code at some point?

@phitho : the issue is fixed now : even with " and ' and , inside name firstname etc : you can oprn the csv file after.

The feature is here : https://bugs.limesurvey.org/view.php?id=16683

See https://bugs.limesurvey.org/view.php?id=16647#c59914

@DenisChenu: Thank you, but why doesn't it work then? When I click on "export all participants", I can only select the attributes, but not the separator. Our admin confirmed this. We have Version 3.23.7+201006.

Did you look at discussion ? I answer at previous message …

@DenisChenu: Thank you, I'm sorry, I can't really follow. Does our admin need to change the code at some point in order to make this work? When I export the CPDB, I can't select the separator, it's still ",".

Yes : it's still , but there are no issue when open it via excel or libre office , it's a clean CSV

I have the same issue as in the example csv I sent above.

@phitho What is the issue?
a - You are not able to choose the separator ?
b - The created file (wth the default separator) is corrupted?

Thanks!

@gabrieljenik
a - yes, I can only select the attributes to be exported. It looks exactly like the old setup, before the update.
b - the created file with the default separator looks OK when I import it, it seems to put the quotation marks around some answer categories (but not all of them) - sorry for the wrong info yesterday. Still, I would prefer to be able to select a separator and if I understood, this should be working?

It won't be possible to choose a separator - it will add too much work and the process will get even more complicated. Can you give us a use case where the current (update) system does not work as required?