obsidian-db-folder icon indicating copy to clipboard operation
obsidian-db-folder copied to clipboard

[Bug]: CSV export does not escape quotes correctly

Open Novark opened this issue 1 year ago • 0 comments

Contact Details

No response

What happened?

Exporting to CSV should escape embedded quotes by doubling them in the resulting CSV output file.* * Per RFC 4180 (Section 2.7)

Example database table:

name | description | quantity
Novark | This is a "fancy" description | 10

Should result in the following CSV:

name,description,quantity
Novark,"This is a ""fancy"" description",10

However, this is the current output (note the lack of double-escaped quotes around "fancy"):

name,description,quantity
Novark,"This is a "fancy" description",10

This effectively breaks CSV compatibility in many third party programs.

What platform were you using?

Desktop

Version of the plugin

3.5.0

Relevant log output

No log file necessary

Are you using the latest version of the plugin in your Obsidian vault?

  • [X] I have verified that I am on the latest version

Are you check if there is a similar issue?

  • [X] I have verified that there are not similar issues

Novark avatar Oct 01 '23 12:10 Novark