Does anyone know how to specify a row delimiter other than carriage return with SQL Loader? I want to specify a double quote followed by carriage return as the delimiter. The problem that I'm having is someone will type a CR in a comments field and sql loader will think its a new row.

"field1", "comments field", "last field"<CR> --- THis works ok

"field1", "comments<CR>
field", "last field"<CR> --- This fails because it looks like 2 rows

If I could specify "<CR> as the row delimiter, I think sql loader would ignore the <cr> in the comments since it doesn't have a " before it.

Any suggestions?