Windows to Unix. Text files.
When I ftp a text file to the unix server, all the carriage returns are represented by some characters. As a result when I load this file into my oracle database, the last column contains some unreadable characters and my select queries fail.
The only way of preventing this to open the file in textpad and save it for Unix. Then everything goes well as intended.
How do I do this without using textpad? Can this be done in notepad for instance.
Re: Windows to Unix. Text files.
It should be easy enough to do with a simple bit of VB code. The difference is the 'new line' marker, which for Windows is Chr(13) + Chr(10), but in *nix (I think) is just Chr(10).
A simple call to Replace would do the conversion.