Dos2Unix

[aghosh]

Hi,
I am doing a database upload from an Oracle8i database on WinNT to Oracle8i on RedHat Linux.

I have exported the data as separate insert statements and have FTPed the file from WinNT server to the Linux server. But on the Linux server I find a character like ^M after each line in the datafile.

On Unix there is command called dos2unix which converts the dos format file to unixformat file. But I am not sure of the similar command on Linux. I am really stuckup.

Someone please help.


Thank you,

Amitava

[aracnid]

On Solaris systems, you can use the dos2unix command.
This converts a text file from DOS format to ISO format

[denevge]

repeat the ftp. Use asc mode instead of bin mode.

This will do the conversion for you.

Hope this helps
Gert

[pwoneill]

Yeah if you're sending an ascii file from dos to linux make sure you use ascii, binary puts all the ^M's at the end. I'm not sure if there are any default programs on a RH install to do that (maybe dos2unix but never checked for it), I just write a little script that does it for me if I feel like it. It's not that hard and once you code it the first time you could use it again without having to resend anything, or use if resending isn't fixing the problem.