Copy To CSV and Field With Quotes and Commas

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Copy To CSV and Field With Quotes and Commas

Message

02/04/2009 01:13:11

Brandon Harker
Sebae Data Solutions, Inc.
Floride, États-Unis

30/03/2009 18:57:32

Sergey Berezniker
New York, États-Unis

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Copy To CSV and Field With Quotes and Commas

Versions des environnements

Visual FoxPro:

VFP 9 SP2

OS:

Vista

Database:

Visual FoxPro

Divers

Thread ID:

01392202

Message ID:

01392686

Vues:

>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

Répondre

Fil

Voir

Click here to load this message in the networking platform