Becky,
You can also use the TEXTMERGE command to easily create this file.
set textmerge to TheOutput.txt
set textmerge on
scan
\\<<field1>>,<<field2>>,<<field3>>
\
endscan
set textmerge off
set textmerge to
You can also more generically use afields() to create an array of fields to put out, but it'll run slower.
>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)