Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Delimited text output without quotes?
Message
De
17/11/1999 18:44:21
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00292190
Message ID:
00292191
Vues:
24
>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

Try:
COPY TO file.txt TYPE DELIMITED WITH " "
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform