使用包含数据换行符的文本字段将CSV导入MySQL Workbench

Question

Tried loading csv from a spreadsheet into MySQL Workbench using a solution found here

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv' INTO TABLE test.dummy FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '
';

The data loaded but some cells in the spreadsheet already contain new line characters. In these cases the LOAD created a new record.

Mathematics Kindergarten,Counting,"Say the number sequence 0 to 1000 forward and backward by:
- 5s, 10s or 100s, using any starting point 
- 3s, using starting points that are multiples of 3
- 4s, using starting points that are multiples of 4
- 25s, using starting points that are multiples of 25."

With a Table Like in this format:

 Course   |   Topic    | Description

The data loaded like so:

Mathematics Kindergarten   |    Counting    | "Say the number sequence 0 to 1000 forward and backward by:
- 5s, 10s or 100s, using any starting point              |                | 
- 3s, using starting points that are multiples of 3      |                | 
- 4s, using starting points that are multiples of 4      |                | 
- 25s, using starting points that are multiples of 25."  |                | 

How can I have the system recognize to load the data so that the whole cell contains the full description and it's not broke over X records.

Answer 1

The steps had me return to the document that I exported the CSV. I had to sanitize the data.

Find and Replace Carriage Returns and Newline Character present in cells with . Also found some other cells that had comma , into html number ,

This corrected the issues with the data import tool of MySQL Workbench.