Thread: ftp to Unix
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default ftp to Unix

The ^M in dicates there is both a Carriage Retiurn and line feed at the end
of a line. Windows puts both the line feed and CR in the file while Unix
only has CR. On most UNIX machines there are two commands unix2dos and
dos2unix. Running dos2unix filename newfilename will fix the problem.

"ng42" wrote:

I am transferring data from a s/s to a Unix server using the 'save in'
feature Add/Modify FTP Location, but each line has ^M at the end of it. This
is normally caused by the transfer protocol. Is this set in Microsoft or the
Unix server?