Hi ,
I am using sql loader to load data from my file (csv) to the table. I am replacing with the pipe symbol in my unix script and loading into the table using sql loader.
I have used pipe symbol as delimiter in the sql loader.
ie. fields terminated by '"|". There are specific fields which contain the delimiter inside the field
for eg: Address_1 field has C|O 3rd STREET
Because of this, it treats as separate fields and getting inserted to adjacent columns in table.
Pls suggest is there a way to ignore the delimiter in specific fields in the sql loader control file
Thanks