How to make SQLLoader to understand \n as part of string
- From: Mindaugas Navickas <mnavickas@xxxxxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Aug 2006 17:23:04 -0400 (EDT)
Hi,
May be somebody faced this issue before and knows how to solve that.
We have a CSV file where text fields enclosed witrh ("). The issue is that text
fields might contain \n (new line - 0x10) character which is treated by
SQLLoader as record terminator. Is it any way to tell loader that \n when met
after opening apostropha to be treated as part of field and not as record
terminator. Here is sample data (note the first line - bbb\nbbbshould be part
of the same field:
111,"aaaa","bbb
bbb","ccc"
222,"xxxx","yyy",
333,"ffff","ggg","hhhh"
Thank you
Mindaugas Navickas
OCP DBA
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
