General information
Category:
Coding, syntax & commands
>>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only