URGENT:SQLLDR, concatenating 2 columns

From: <pmohanan_at_my-deja.com>
Date: 2000/07/18
Message-ID: <8l2knf$ep6$1@nnrp1.deja.com>#1/1

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 Tue Jul 18 2000 - 00:00:00 CDT