Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CSV with double quotes
Message
De
09/03/2017 06:10:20
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
01648804
Message ID:
01648874
Vues:
53
>This gets rid of the dang double quote problem....
>
>COPY to myfile.csv delimited with "" with character '|'
>
>...if you do that command it creates a file without those stupid quote marks, delimited with the pipe symbol.
>
>...Sorry I was late to the game here I didn't notice the thread till just now - but perhaps this can help you out now or in the future. This is one quirk that got me stuck in the past.

Victor,
I couldn't understand how this would solve the problem. Wouldn't it be a new and more serious problem in itself? If for a second you think it could work, what would happen to a field that contains | ? Or a field with comma, apostrophe, tilde ... in it? Or one with date time data? I would repeat my warning that trying to transfer data to Excel using text is asking for trouble (unless that text is a well known data interchange format, say, XML).
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform