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?
请先登录再写评论。
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.