-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|