Importing from CSV where values have multi lines
Hi,
I cannot seem to import CSV file into a table if some of the values in the file have multi lines. DataGrip warns that there is no data to import.
Is there a work around for this?
Please sign in to leave a comment.
How can DataGrip distinguish new line from the multiline values?
The only way is to quote multiline values.
You are right Max!
Additionally, the row separators in the CSV file and selected in the DataGrip's import dialog need to be anything but newline.
Thanks for the advice.