sqlldr with carriage returns

Help!!

I am trying to run a sqlldr program that loads a flat file delimited by | and that has a carriage return at the end of each row.

Ex: 12|desc|34^M

     1234|desc|3456^M

I need to know how to tell sqlldr that the last field is terminated by a carriage return. The only thing that sqlldr will except with the terminated by statement is one char or the hex of one char. I do not know how to represent a carriage return in this manner.

Any help would be greatly appreciated!

Thanks

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet