Re: SQL*Loader line breaks in fields CSV file

From: Tony Sequeira <tony_at_sequeira.org.uk>
Date: Sun, 21 Mar 2010 09:14:14 +0000
Message-ID: <4BA5E366.8030203_at_sequeira.org.uk>



Hi Adar,

Andrey was indeed on the right lines. However, if you look back at the postings I mention:

"I believe that I will have to manipulate the datafile..."

"without manipulating the datafile."

And indeed Adar solution worked, *BUT* I had to edit the relevant datafiles, I've been given them, I have no opportunity to amend the way they are created.

Regards.

Yechiel Adar wrote:
> Read Andrey lips. The link he gave you is right on the money.
> You are looking on the data with the wrong tool.
>
> Since you produce somehow a csv file, you should be able to "select
> *,'|' from table;".
> The spooled output file is a long string of characters that contained /n
> in some places.
> Sqlldr reads and understand this string according to the parameters.
> If you use the "str '|\n'" then sqlldr will treat /n as regular
> character and use only |/n as end of record.
>
> When you look at the file with a regular editor, the editor treats the
> /n as new line and present it to you in one way.
> Sqlldr will treat it in a different way.
>
> Adar Yechiel
> Rechovot, Israel
>
>
>
> andrey khudyakov wrote:
>
>> http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_load_records_with_multi-line_fields.3F
>>
>>
>>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>

-- 
S. Anthony Sequeira
++
Now I lay me down to study,
I pray the Lord I won't go nutty.
And if I fail to learn this junk,
I pray the Lord that I won't flunk.
But if I do, don't pity me at all,
Just lay my bones in the study hall.
Tell my teacher I've done my best,
Then pile my books upon my chest.
++


--
http://www.freelists.org/webpage/oracle-l
Received on Sun Mar 21 2010 - 04:14:14 CDT

Original text of this message