Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to append from CSV where some fields have quotes
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01144038
Message ID:
01144477
Views:
14
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?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform