Export CSV/TSV with multi-line text columns

已回答

Hello.

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?

0

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

0

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

0

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

0

请先登录再写评论。