How to make SQLLoader to understand \n as part of string

From: Mindaugas Navickas <mnavickas_at_yahoo.com>
Date: Thu, 24 Aug 2006 17:23:04 -0400 (EDT)
Message-ID: <20060824212304.57267.qmail@web30108.mail.mud.yahoo.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 24 2006 - 16:23:04 CDT