SQL Loader 1

[asb555]

Hi Guys,
I am trying to load some data into Oracle using sql loader. The fields are separated by commas. The problem i'm having is that some of the fields have trailing whitespaces, which i don't want to load.

ex: John ,Michael,Thomas ,Henry

how can i do this using sql loader?

Thanks in Advance.

 

[karluk]

If I'm reading the SQL*Loader documentation correctly, it looks as if you will need to use the RTRIM function in your control file for each column that might have trailing blanks. Something like the following should work

field1 CHAR TERMINATED BY "," "RTRIMfield1)"

 

[asb555]

Thanks karluk!!