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
 Tags
Subject: copying a dbf to text files
Thread ID: 143479 Message ID: 143479 # Views: 4 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, August 29, 2007 6:11:37 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

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