I'm trying to use sqlldr to load a pipe-delimited flatfile into a table with a LONG datatype. That's not hard, except that the text to be loaded into the LONG column is full of cr/lf (they're resumes, and the data owner wants the formatting preserved).

Control file looks like this:
LOAD DATA
INFILE 'MD029candidateinfo.txt'
BADFILE 'MD029candidateinfo.bad'
APPEND
INTO TABLE candidates
FIELDS TERMINATED BY "|"
(
candidateid,
active,
resumertf char(200000) ENCLOSED BY '"' AND '"')

Datafile looks like this:
12345|1|"Resume of Larry Ellison...^M
resumetext....."^M
67890|2|"Resume of Bill Gates...^M
resumetext......"^M

The '^M' characters are the way Unix displays the cr/lf values. I've tried substituting them with various other characters, however my log and bad files from SQLLDR indicate that SQLLDR thinks the '^M' character signals the start of the next record. Please help!

Thanks,

Joe