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


Thx,

Still have a prob though. If I go

copy fields desc to myfile.txt delimited with ''

It then looks like this:

'T.AAI.UN'
'T.|||'

I can't seem to set a delimiter which will not put the apostrophes or " at the ends. Even if I go

delimite with blank or delimited with tab it still puts " on the left and right.

I'll keep working on it or may have to use sdf.

THX
bob





> > 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