Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to append from CSV where some fields have quotes
Message
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:
01144477
Vues:
22
You're right about the DELETE, didn't figure out at start why you included it. In the end, this was really the solution i used. I created a table with all char fields, appended including field names, then deleted first row. Afterwards moving data from char to respective types was a breeze.

Thanks for your help
Jaime

>Sure it does. That's why I added DELETE command to my code. You can also use FOR clause to filter out the first row.
>
>>That's exactly the first thing i tried, but it imports the field names from the first row as well in this case...I'll have to strip them before importing then...
>>Jaime
>>
>>>Try
>>>APPEND FROM temp.txt DELIMITED WITH CHARACTER "," WITH ""
>>>GO TOP
>>>DELETE
>>>
Why do programs stop working correctly as soon as you leave the Fox?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform