Problem importing data when one field contains a return (4334542)

Problem importing data when one field contains a return.

To reproduce this issue follow the steps below:

1) Create table test_import

create table test_import (
col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10),
col4 varchar2(10));

2) Create a csv file (importTableWithReturn.csv) with this contents (notice the return after "bb)

"aaaa1","bb
bb1","cccc1","dddd1"
"aaaa2","bbbb2","cccc2","dddd2"
"aaaa3","bbbb3","cccc3","dddd3"
"aaaa4","bbbb4","cccc4","dddd4"

3) Go to Schema Browser and select the table test_import
4) R-click and select Import Data.
5) Select the file (importTableWithReturn.csv)
6) You will see that the import is not correct as toad imports only two columns.

The problem is with the return in the middle of the column
"bb
bb1"

As the the delimiter is a , and the Text qualifier is " this rows fits the requirements to be successful imported and it is not.

With Toad 9.7 it was possible to import this rows.
,

WORKAROUND

Remove the return in the csv

STATUS

Waiting for fix in a future release of Toad for Oracle