Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COPY TO command - don't want quotes
Message
De
29/01/2014 16:39:39
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01592594
Message ID:
01592597
Vues:
61
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform