Simple quote doesn't work in CSV export wirth separator ;

[AmaurySchmitt]

Good morning all,

I encounter a problem when exporting my data, in fact when I export my data in CSV with the separator: ;
my data having single quotes is not taken into account and shows me: &#39, the problem is that this shifts my data and blocks me for the import.
Thanks in advance for your answers !

My custom settings for export :
public function getCsvSettings(): array { return [ "delimiter" => ";", "input_encoding" => "UTF-8", "enclosure" => "", "line_ending" => PHP_EOL, "use_bom" => true, "include_separator_line" => true, "excel_compatibility" => true, ]; }

[patrickbrouwers]

You probably need to set the enclosure to "

[AmaurySchmitt]

But why I have this for the single quote when I export my data : ' ? Knowing that in my database the single quote is displayed correctly

[patrickbrouwers]

Don't know, we just pass the data on to PhpSpreadsheet. Could be something on your side or PhpSpreadsheet does something to the string.