Comma Delimited File Create

[Atlas]

I need to create a comma delimited file for a vendor for upload into their system. I sent them one file created with the command copy to myfile.csv CSV but they they need a file that does not have charater string surrounded by ".
I have tried different commands but I can seem to get the file to copy without the quotes. Instead of this in the file

"LUFKIN ISD","HELEN STROHSCHEIN","9366346696"

they want this

LUFKIN ISD,HELEN STROHSCHEIN,9366346696

I tried different commands but still can't get this right.

Any help would be appreciated.

Thanks
Atlas

 

[Mike Lewis]

Atlas,

Have you tried this:

COPY TO "myfile.txt" DELIMITED WITH ""

Works for me.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[StewartUK]

Atlas,

Try COPY TO MyFile DELIMITED

Stewart

 

[Mike Lewis]

Stewart,

I think he needs the WITH "" clause, otherwise quotes will be used as the default delimiter.

Mike


Mike Lewis
Edinburgh, Scotland

http://www.ml-consult.demon.co.uk

 

[StewartUK]

Oh yeah! Thanks Mike.

 

[Atlas]

I tried the Copy to Delimited with " " got rid of the qoutes but have spaces at beginning and end of each string

003903 , LUFKIN ISD , HELEN STROHSCHEIN , 1806 MARTIN LUTHE , , LUFKIN , TX

want this

003903,LUFKIN ISD,HELEN STROHSCHEIN,1806 MARTIN LUTHE, ,LUFKIN,TX

Tried Copy to Delimited with "" but get error message
Command contains unrecognized command/keyword. Must be doing something wrong.

Thanks

Atlas

 

[rgbean]

Atlas,
COPY TO "myfile.txt" DELIMITED WITH ""
Will work as you want it to in VFP 7.0 & 8.0, but isn't syntactically correct in VFP 6.0 (SP5). :-(

If you are stuck in 6.0, you may need to get creative using something like:

set safety off
xx = chr(127)
COPY TO myfile.txt DELIMITED WITH &xx
strtofile(chrtran(filetostr("myfile.txt"),"&xx",""),"myfile.txt")
set safety on

Rick

 

[ramani]

Hi ATLAS

COPY TO myFile.txt DELIMITED WITH ""

1. no space between the "" marks
2. If you omit the myFile.txt error will be reported.
use myFile.Txt or replace it with filename you want



ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[Atlas]

Thanks to all the code from rgbean does the job. Should have upgraded to VFP 8.0.

thanks

Atlas