Copy To CSV and Field With Quotes and Commas

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 01:13:11

Brandon Harker
Sebae Data Solutions, Inc.
Florida, United States

30/03/2009 18:57:32

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:

01392686

Views:

>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

Brandon Harker
Sebae Data Solutions

Map

View

Click here to load this message in the networking platform