Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to append from CSV where some fields have quotes
Message
From
09/08/2006 07:44:58
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
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:
01144046
Views:
14
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform