SQLLDR / CSV problem

blindsey · *nix forums beginner Joined: 19 Jul 2005 Posts: 4

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?

Maxim Demenko · *nix forums Guru Joined: 24 Apr 2005 Posts: 428

blindsey schrieb:

psoug · *nix forums Guru Joined: 15 May 2005 Posts: 3492

blindsey wrote:

Google