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".