| SQL Loader: problem loading csv file with extra commas [message #318454] |
Tue, 06 May 2008 21:47  |
pbdougl
Messages: 2
Registered: May 2008
|
Junior Member |
|
|
Hi; I have a csv file extracted out of a foreign database with a text field at the end that contains commas. I want to load all columns except this last text field into Oracle using sqlldr but keep getting errors.
Data example:
Header:
Account,Assigned,LatestNote
Data:
748004546,1/08/2007,DO NOT BILL
712345745,1/10/2007,OK, EXCEPT CUST UPSET
From the above example, I only want to load columns Account & Assigned because if I load them all the comma in line2 obviously creates problems.
Pls help me.
PD
|
|
|
|
|
|
| Re: SQL Loader: problem loading csv file with extra commas [message #319339 is a reply to message #318454] |
Fri, 09 May 2008 22:43  |
TheSingerman
Messages: 49
Registered: April 2008
Location: Brighton, Michigan
|
Member |
|
|
I'll take a guess, and state that you don't have a real .csv file. You have something that looks a lot like a .csv file, but it isn't a real one. A real one would get picked up by a spreadsheet application without any problem, and yours won't.
The last line in A Real .csv File would look like this:
"712345745","1/10/2007","OK, EXCEPT CUST UPSET"
So recreate your .csv file with quotes as field terminators, modify your control file, and you should have no problem.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
