Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to append from CSV where some fields have quotes
Message
De
09/08/2006 07:44:58
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Divers
Thread ID:
01144038
Message ID:
01144046
Vues:
20
>Hi
>I am trying to append from a CSV file using
>APPEND FROM CSV
>
>The command completes succesfully, but i have problems in fields containing quotes. For instance if a field contains the value [A"B], i will have A in the current field, then B in the next field ( which is weird, since the fields are delimited with a , ).
>
>Thanks for your help
>Jaime

Jaime,
If you're creating the file then create it with:

Copy To xx.txt type delimited with ""

in the first place and 'append from ... type delimited'
Cetin
Ç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