Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yull67
  
 
 
 Yull67
 To: Bob Stranks
  Where is Bob Stranks?
 Vancouver
 Canada
 Bob Stranks
 Tags
Subject: RE: copying a dbf to text files
Thread ID: 143479 Message ID: 143480 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, August 29, 2007 6:26:18 AM         
   


> Hi,
>
> I've always had trouble with this one. Lets say I have a dbf file with one field called "desc" which is 100 characters wide. I want to copy for example a record that says "brian anderson" to the contents to a text file but
>
> a) if I go "copy to myfile.txt sdf
>
> then it will also copy all the spaces so that it is still 100 characters wide.
>
> eg
>
> brian anderson then about 90 spaces.
>
> b) if I go "copy to myfile.txt delimited with blank
>
> then it will copy like this
>
> "brian anderson"
>
> b above is okay since there are no spaces after the quotations but I don't want the quotes either. I want
>
> brian anderson
>
> and have no spaces after it
>
> there seems to be no copy to delimited option that will do this.
>
> Hope I am making sense.
>
> thx
> bob

Hi Bob,

Of course there is:
COPY TO FileName DELIMITED WITH Delimiter


Example:
COPY TO FileName.txt DELIMITED WITH ""


Regards,
Yull

ENTIRE THREAD

copying a dbf to text files Posted by Bob Stranks @ 8/29/2007 6:11:37 AM
RE: copying a dbf to text files Posted by Yull67 @ 8/29/2007 6:26:18 AM
RE: copying a dbf to text files Posted by Bob Stranks @ 8/29/2007 6:38:12 AM
RE: copying a dbf to text files Posted by Yull67 @ 8/29/2007 6:43:16 AM
RE: copying a dbf to text files Posted by Bob Stranks @ 8/29/2007 6:59:59 AM
RE: copying a dbf to text files Posted by Cetin Basoz @ 8/29/2007 1:46:21 PM
RE: copying a dbf to text files Posted by Yull67 @ 8/29/2007 6:58:22 AM