SET TEXTMERGE TO [name].TXT NOSHOW SET TEXTMERGE ON
Then :
\<><<'|'>><><<'|'> etc etc etc
(we use pipe separators)
However, I think that the CHRTRAN() command may work..
Regards
Chris
>How are you creating the file? > >As Alan said, use only chr(10) for Unix, not chr(13) + chr(10). > >You can use chrtran() to replace all chr(13) into chr(10) and strtran() to replace all chr(10) + chr(10) into chr(10). > >Vlad > >>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? >> >>Thanks >> >>Chris Kable >>FuelTrac