How would you write a control file for Oracle SQL Loader that treats each record as being composed of 3 commas?
I have read the documentation, however I cannot find how to handle this scenario, without having to edit my data file by hand.
For example, my data file has:
fd,3232,gfd67gf,
peas,989767,jkdfnfgjhf,
dhdhjsk,267,ujfdsy,fuyds,637296,ldosi,fduy,
873,fuisouyd,try
save,2837,ipoi
I would like to load the data into the table looking like this:
col1 col2 col3
fd 3232 gfd67gf
peas 989767 jkdfnfgjhf
dhdhjsk 267 ujfdsy
fuyds 637296 ldosi
fduy 873 fuisouyd
try\nsave 2837 ipoi
Note: Where I have "\n" in the last row of col1, I mean an actual line feed not literally "\n".