I'm trying to load a file with description columns which may contain newline characters. The file is Unix format utf16, tab separated and description columns are enclosed in ". The problem is bulk loader assumes the newline is end of record even though it is enclosed in the " characters, and it would create more rows than there should be.
Here's an example of the record I tried to load:
2 "some more ""
3 "even more '
Here's what I have for my control file:
append into table load_table1
fields terminated by " "
optionally enclosed by '"'