Are you using VFP7?
If so, have you tried:
COPY TO newfile.txt DELIMITED WITH "" WITH CHARACTER ','
>I have a dbf of about 80,000 500-byte records that needs to be written out to an ASCII text file for upload to another system. They want it comma delimited WITHOUT the quotes on text fields. When I do the COPY TO DELIMITED, I get the quotes around the fields.
>
>I have tried the strtofile function below which works on smaller files but on one this large, I get an out of memory error.
>
>Is there some way to parse the file and do it a little at a time? Or is there a better way to get an ASCII file.
>
>Thanks for any help you can give me.....here's what I tried:
>
>llReturn=strtofile(strtran(filetostr(lctempfilename),["],''),lcnewFileName)
>
>Becky
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"