SQLLDR / CSV problem

From: blindsey <blindsey_at_dsicdi.com>
Date: 12 Jul 2006 07:14:34 -0700
Message-ID: <1152713674.565472.132280_at_i42g2000cwa.googlegroups.com>

[Quoted] [Quoted] I'm trying to load some client data in CSV format using SQLLDR.

The problem is that the text fields in the data contain CRLFs which SQLLDR can't tell from record-ending CRLFs.

Before I go off trying to write one myself, is there some sort of utility which would recognize that a CRLF is within a field's enclosing characters and strip it out or replace it with something else?

Or another way to solve the problem? Received on Wed Jul 12 2006 - 16:14:34 CEST