Hi,

One bank statement file should be loaded into some tables by using a concurrent program. But if the file is transfered in binary mode i am getting some special characters in the file which is unexpected. so, for that while moving that file data into tables i want to write a script that checks whether the file is in binay mode or in Ascii mode?? If it is transfered in binary mode, then i want to display one error message that the file should not be transferred in binary mode.

I think my explanation is clear.

can any one let me know what is the command to check whether the file is in binary mode??

Thanks in advance.
Sateesh.

Why not run the file through dos2ux (dos2unix on some machines). If the file is "binary" it will get changed automatically. IF not, it won't be touched.

Just a comment,
I think it's a bad habit of most ftp-implementations to default to converting data between systems, ie ASCII transfer. I would rather always transfer the data in binary, exactly, or at least as closely as possible, as it is represented on "the other" system, and make the conversion myself. I know what it looks like on one system and and I know how I want it on another. It is better to control it Yourself than letting someone else (the ftp-client) to convert it the way it thinks it should be, because that may differ between clients and methods.
I think You will find that binary mode transfers don't add or change anything in Your data. It is ASCII-mode that usually converts line breaks, character sets between platforms, etc.

Then again, ASCII may be the way You want it or expect it...

file is a command to check the type of file, it may not always be completely accurate. The FTP-definition of binary is not shared by all...

and as jim pointed out, running it through dos2unix, shouldn't hurt, as long as it's "text" data, it could actually wreak havoc in some data files, such as xml CDATA, or sql with "binary" BLOBS.

/Lakris