Shell Programming and Scripting

Hello -

I have text file and need to load the data in Oracle through sqlloader.
I need to move this file to unix server and load into oracle. When i SFTP(unfortunately i do not have FTP)
to unix box, each line is appended with ControlM character...
since it is transferring in BINARY format.. I checked the SFTP help.. Here is the help info.

Code:

Unfortunately not.

Until recently, this was a limitation of the file transfer protocols: the SCP and SFTP 
protocols had no notion of transferring a file in anything 
other than binary mode. (This is still true of SCP.)

The current draft protocol spec of SFTP proposes a means of implementing ASCII transfer. 
At some point PSCP/PSFTP may implement
 this proposal.

After sftping the text file into unix, here is the file content.

Code:

F2|Invoice||x^M
F2B|Nota fiscal||x^M
G2|Credit Memo|x|x^M
G2B|Credit memo BR|x|x^M
L2|Debit Memo||x^M
L2B|Debit memo BR||x^M
RE|Credit for Returns|x|x^M
REB|Ret. credit memo BR|x|x^M
S1|Cancel. Invoice (S1)|x|x^M
S2|Cancel of Cred Memo||x^M
WIA|Plants Abroad||x^M
Z2|Revenue Recong.Billi||x^M
ZFVB|BR Contract Invoice||x^M
ZFVI|Invoice Contract||x^M
ZL2|Debit Memo||x^M
ZL3|Debit Memo Deposit||x^M
ZL4|Credit Memo Deposit|x|x^M
ZFIN|MAC Order ||X^M
ZMSV| Monthly Maintenance Invoice||X^M
ZREY| Avaya Install Rev Recognition (no customers)||X^M
ZTMI| T&M or Term Fees||X^M
ZVMI| Managed Services Mac Order||X^M
ZVSV|Managed Services Maintenance ||X^M

Sqlloader treats ^M as another character and trying to load that charcter...

My sqlloader is failing due to this reason.. How can i handle this situation?

Please let me know if you see any possible solutions...

One option would be to remove this ^M character before we load it. But i don't know how to remove this character...

Any help please....

look into 'man dos2unix'
or

Code:

tr -d '\r' < myFile > myNewFile

Thank you. You are the Man!!!

are you sure?

Certainly !!!