Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copy To CSV and Field With Quotes and Commas
Message
From
02/04/2009 06:50:11
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Copy To CSV and Field With Quotes and Commas
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01392202
Message ID:
01392700
Views:
57
>>You have to double double-quotes before copy to csv file
>>
>>...
>>UPDATE c_test SET textfld1  = STRTRAN(textfld1, ["], [""])
>>COPY TO myfile.csv TYPE CSV
>Hmmmm... I swore I tried that before posting. I must have used chrtran() instead of strtran() which of course would have done nothing.
>
>Thanks Sergey

You're welcome
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform