Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement