Re: URGENT:SQLLDR, concatenating 2 columns

The problem is that SQL*Loader treats carriage returns as record seperators.

What I have done in the past is to do a search and replace of the source data.

For instance I will search
all ascii 10's and replace them with 128's all ascii 13's and replace them with 129's

Then in the SQLLoader control file I use the SQL translate function to convert them back.

Hope this helps....

<pmohanan_at_my-deja.com> wrote in message news:8l2j9r$dh1$1_at_nnrp1.deja.com...
> Hi....Oracle Gurus,
>
>
> I am having a problem while loading records into oracle. One of the
> column is a text field in sybase. when i downloaded the data it puts
> "\n" or newline between the 2 rows i.e the row looks like this
>
> dskfjdskf|3242432|ksdjfksdfj|Hi Please help
> me|324324234234
>
> Now, my problem is that the stmt "Hi Please help me" is one line with
> delimiter "|". All the rows doesn't have this problem. The data is
> variable length. How do i tell the SQLLDR to scan the current column
> till it reaches "|" in case it doesn't get the data for all fields.
>
> TIA,
>
> Praveen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Jul 24 2000 - 00:00:00 CEST