hi

The following method helped me once to remove the blanks at the end while loading.But the column values where continuous without any spaces within them.

ES_ERROR "substr(:ES_ERROR,1,instr(:ES_ERROR,' ')-1)" ,

But trim function suggested by Pando is best because the above method might truncate some values if there are spaces inbetween the column values.

regards