>Hi everyone
>
>We are sending a text file to a customer running a UNIX machine (yuk) and they seem to have a problem with a ^M character at the end of each line (I think that this is the carriage return?). Does anyone know how I can strip out this character so it doesn't cause them heartache?
>
There are many ways to do this at various points in the process of creating and sending the file. Without knowing the specifics of how you create the file, I can only give some general guidelines. If you manually create the file line-by-line, use only chr(10) for the end of line sequence. If you use one of the FoxPro methods to create a text file, you can use the method posted by David Frankenbach to remove the chr(13) characters (^M characters). If you are sending the files to the client via FTP, set your FTP mode to ASCII and it will automatically convert the file to Unix text format. As Alan Trosky pointed out, there are many utilities to convert the files as well once they are on the Unix server. It is also quite easy to write your own script to remove those pesky ^M characters.
Melissa Danforth
Customsoft Corporation