Re: SQLLDR / CSV problem

blindsey schrieb:
> 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?
>
You could use perl,python,awk... to preprocess your data, or pick one of approaches from here
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1286201753718

Best regards

Maxim Received on Wed Jul 12 2006 - 16:32:52 CEST