Export CSV/TSV with multi-line text columns



I'm trying to export a query from one server and import the result into another. The result contains a number of text columns with line breaks. When I export as either CSV or TSV, the line breaks are not escaped, and the resulting file is invalid.

I can export as JSON, in which case line breaks are correctly escaped, however DataGrip does not seem support data import from JSON.

What can I do in this case?


What is the version of DataGrip? The issue with line endings should have been fixed in 2022.2
If it is still there, please share an example of such CSV


I am running DataGrip 2022.2.3 and have same issue with CSV export not quoting multiline fields


Paul Robello, is there a chance to share a CSV file? You can upload it to http://uploads.jetbrains.com/ and provide its ID.