Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating a CSV file with COPY TO
Message
 
 
To
24/04/2001 01:55:51
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00498815
Message ID:
00499063
Views:
23
>>I am driving myself nuts. Can this be done ? A simple CSV. No delimiter just commas to separate the fields. I am trying the DELMITED WITH BLANK ... and it still gives me a " for a delimiter !! HELP !!
>>
>>Thanks, Ken
>
>Kenneth,
>Either copy to... type delimited or type CSV produce output using quotes as text delimiters. You could use delimited with ' ' but that adds extra space around text.
>You could do this :
>
copy to myFile.txt type delimited
>StrToFile(chrtran(FileToStr('myFile.txt'),'"',''),'myOutPut.txt')
Cetin

Also take a look in the recent FAQ "Removing double quotes from the file" which is based on Cetin's fll :)
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform