>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),'')
strtofile(m.lcFileStr,'myFile1.txt')
append from myFile1.txt
If it's not broken, fix it until it is.
My Blog