Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Copying to a Delimited File - Getting Rid of Quote Marks
Message
De
26/05/1999 09:34:26
 
 
À
26/05/1999 09:25:25
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00222810
Message ID:
00222895
Vues:
24
>>I am trying to copy a dbf to the equivalent of a .csv file (comma separated). If I use the VFP command:
>>
>>COPY TO file DELIMITED WITH CHAR ,
>>
>>It will separate the field with commas but it also puts quotation marks around the character fields (apparently because commas may be in the text). I don't want to send that. I want strict comma delimited.
>>
>>Any suggestions???
>>
>>Thanks always everyone for the advice.
>
>I just tested this:
>
>copy to bob.txt delimited with , with character blank
>
>and it does what you want.
>
>BOb

Sorry, I guess this doesn't do what you want, it actually uses space around text instead on a quote. I guess you will have to do something like...

copy to MyFile delimited
cMyFile = FILE2STR( 'MyFile.Txt' )
cMyFile = STRTRAN( cMyFile, '"',"" )
STR2FILE( 'MyFile.Txt' )

BOb
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform