>Does anyone know how to export a FoxPro table to a comma delimited text file? In other words, I want every field value delimited by a comma with no quotes around character values. TIA
While you can
Appe from commas.txt delim
For copying into such a file you'd have to do a thing like this:
set print to commas.txt
set print on
lnFieldCount=afields(aStru)
scan
lc_comma=""
for i=1 to lnFieldCount
?? eval(aStru[i,1])
lc_comma=","
endfor
?
ends
set print off
set print to
You may want to check for type of the field and trim the strings, check if the strings themselves contain commas...