Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
COPY TO command - don't want quotes
Message
From
29/01/2014 16:39:39
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Miscellaneous
Thread ID:
01592594
Message ID:
01592597
Views:
59
>I'm dong this:
>Copy to myfile.txt type CSV
>..to create a text file that is comma delimited. My problem is that some of the fields end up in quotes. Is there an easy way to keep that from happening? (I don't want the quotes)

I guess it's there for the fields which may contain commas.

You can always do a filetostr(), then remove each quotation mark that's adjacent to a comma, cr or lf, bof and eof then write it back. But then what if any of the fields contained quotation marks presumably doubled, to differ from outer ones, and they remain like that...

You may just output as tab delimited, then replace tabs with commas, using the same method. May be safer.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform