John,
Working with memo fields goes pretty fast too:
create cursor xTemp ( n1 n(10), c2 c(32) )
for i = 1 to 10000
insert into xTemp values (i, str(i))
endfor
i = seconds()
copy to xTemp.TXT type sdf
create cursor yTemp ( m1 m )
append blank
append memo m1 from xTemp.TXT
replace m1 with chrtran( m1, chr(10), "" )
copy memo m1 to yTemp.TXT
? seconds() - i
Only takes 15 seconds on a P2-300 machine.
>Is there a way to copy a table to a text file with only carriage returns? It keeps adding line feeds as well and make the file useless for the end result I need.