Thank you all. I decided to use the "edit the data file" advice.This is windows so sed will not work, but I used change.exe instead and it works now fine.
Adar Yechiel Rechovot, Israel Yechiel Adar wrote:
Hello I have date data in a record from txt file.When the field in the record contain '00000000' I want to replace it with '19000101'.How can I convince sql loader to do this? TIA
-- //www.freelists.org/webpage/oracle-l