Check Junk character in sql file

Shell Programming and Scripting
1

Hello,

I have two .sql files which I transferred from Windows to Unix (Linux Enterprise Linux Server release 5.3).I want to ensure that these two files have no junk characters in them.How do I do it in the simplest possible way?

Many thanks
DJ

2

I assume that you mean the carriage-return characters at the end of each line ( ^M ). You could:

1) use dos2unix command on the files, or

2) execute tr -d '\r' < infile > outfile , or

3) use ASCII mode during FTP transfer.