Unfortunately, I'm still in 6.0. Someone pointed me to FAQ #8016, I'm going to try to work with it.
Thanks,
Becky
>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