I need to import a table into a database. The table has a column that contains CSV data. When I extract it to CSV, it escapes each quote properly with double quotes. However when I go to a table and import data using CSV, it appears to be splitting the CSV file by "," causing several more columns to be read than exist. It gets an error when I use the header or skip 0 rows as well.
For example, try to import this:
"COL1","COL2"
"testing","""test1"",""test2"""
When I skip 1 row and use no header, below is what it reads when in reality col2 should be read as: "test1","test2"
