Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delimited text output without quotes?
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Delimited text output without quotes?
Divers
Thread ID:
00292190
Message ID:
00292190
Vues:
61
How can you create a comma-delimited text file without the double quote characters around text fields in VFP6?

I need to create a csv file for use with another application that requires comma separated values, but won't accept the character fields in quotes. I have tried every combination of COPY TO DELIMITED WITH CHARACTER and variations I could think of based on VFP6 Help and the Hacker's Guide entry.
COPY TO file.txt TYPE DELIMITED WITH BLANK
writes a file having quotes around each text field, separated by a blank space (Contrary to the Hacker's Guide).
COPY TO file.txt TYPE DELIMITED WITH BLANK WITH CHARACTER ,
generates a syntax error, while
COPY TO file.txt TYPE DELIMITED WITH ~ WITH CHARACTER ,
creates the file having text fields enclosed in ~ and separated by commas.

This is driving me nuts. (short trip.) Anyone have any solutions?

Thanks,
Neil Preston
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform