Question

export to csv - dont want double quotes around strings

1

I have double quotes around the strings I export to csv (with the standard button for that) and I don't want them. I need the strings without any quotes. Is there a way to achieve this or should I go to java for that?

asked 2011-03-02

Toon Verschoor

2 answers

Michel Weststrate · Answer 1 · 2011-03-02

You should go for java. But be aware that if you don't use quotes, you will break the file if someone enters a semicolon somewhere!

Pieter Bosch · Answer 2 · 2011-03-07

This is very true.

Suggestion: A practical way to avoid problems is to change the separator symbol (use e.g. symbol ~ which is not as many used as ; through users input) instead if you don't use the "" text qualifier in CSV.

In general you DON'T want to use comma (,) as a separator when not using a "" text qualifier, as Michel states that the file can be broken easily.