Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Copying to a Delimited File - Getting Rid of Quote Marks
Message
From
26/05/1999 09:34:26
 
 
To
26/05/1999 09:25:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00222810
Message ID:
00222895
Views:
25
>>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
Map
View

Click here to load this message in the networking platform