Export CSV/TSV with multi-line text columns
Answered
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?
Please sign in to leave a comment.
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.