How to copy to text file without double quotes

[timmappa]

I am using FoxPro 8.00. I am using copy command to copy to tab delimited text file from FoxPro table. I am getting double quotes for each field. Is there any way copy the file without double quotes? Please help

 

[GriffMG]

Well you could try:

use mytable
COPY TO c:\myfolder\mytextfile.txt DELIMITED WITH "" with CHARACTER tab

Watch out for memo fields though!


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Stella740pl]

Try

COPY TO c:\myfolder\mytextfile.txt TYPE SDF

 

[GriffMG]

He (Tim?) did say he wanted it tab delimited.

B-)


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Stella740pl]

Griff, I did notice, but decided to suggest an alternative solution anyway.
It often happens that requirements are rather flexible (and SDF sometimes is accepted instead of TAB-delimited, as long as it is not comma-delimited and has no quotes around text fields).

 

[GriffMG]

True enough, I only use delimited when I need to read in excel.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[timmappa]

Suggestion from Griff is works
"COPY TO c:\myfolder\mytextfile.txt DELIMITED WITH "" with CHARACTER tab"

Thanks
Tim

 

[GriffMG]

glad to help

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.