>Hi
>
>I'm triyng to append a csv file as type delimited into a VFP table - the csv file has carriage return and line feed characters which need removing prior to the append
>
>How can i do this?
>
>Thanks
>
>Colin

Why do you need to remove them?


Try using filetostr/strtofile functions and then CHRTRAN or STRTRAN functions.

lcFileStr = filetostr('myFile.txt')
lcFileStr = chrtran(m.lcFileStr, chr(13) + chr(10),'') && to remove all of them at once - the file will be one long line now

strtofile(m.lcFileStr,'myFile1.txt')

append from myFile1.txt