Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Geovannie Ariola
  Where is Geovannie Ariola?
 Quezon City
 Philippines
 Geovannie Ariola
 To: Ken Murphy
  Where is Ken Murphy?
 Springhill
 Canada
 Ken Murphy
 Tags
Subject: RE: Convert txt file to dbf
Thread ID: 106821 Message ID: 107224 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Saturday, September 16, 2006 12:10:44 PM         
   


> > > > Hi Experts!
> > > >
> > > > Our supplier send us their data in txt format (as per attached file, just part of a huge file) but I dont know how to convert it to dbf file. I need your help, I need this data for reconciliation.
> > > >
> > > > Thanks
> > > >
> > > >
> > > > Vannie
> > > >
> > > > https://www.foxite.com/uploads/5e876345-bf96-4a65-b539-052e69436feb.txt

> > >
> > > Hi Vannie
> > >
> > > It is not a big deal to follow the Subject here and "Convert txt file to dbf". Depending on what you need to do with the information from the text file, you can append it to the plain table, like:
> > >
> > > create cursor tempcrs (txtrecord c(200))
> > > appe from (yourfile) SDF
> > >
> > > Actually your file looks like the text file having TYPE /delimeted with character "|"/. So, you may use this TYPE with APPEND command.
> > >
> > > However I do not think it is the case here because you have at least three types of records (as it is indicated in your reply to Tushar). If you wish to create a relational database, then each type of records probably should go to the separate table. And those tables should be linked to each other.
> > >
> > > To conclude, my point is that you probably need to follow the particular business rules when working with this file; just appending to the table will not help too much.
> > >
> > >
> > > Best Wishes,
> > >
> > > Yuri Rubinov

> >
> > Guys,
> >
> > Thank you very for time you had spent reading and giving advice to my inquiry.
> >
> >
> > Vannie

>
> Vannie,
>
> Keep us posted on how you made out.
>
> Ken
> You shall know the truth - and the truth shall set you free. (John 8:33)

Sir Ken,

What I did since it is urgent I ask for an excel instead of text file.

But still I am looking for the solution to my problem.

Once I got the solution will post it here.

Again, to all of you Guys thank you.


Vannie

ENTIRE THREAD

Convert txt file to dbf Posted by Geovannie Ariola @ 9/13/2006 4:20:33 PM
RE: Convert txt file to dbf Posted by Eric den Doop @ 9/13/2006 4:55:57 PM
RE: Convert txt file to dbf Posted by tushar @ 9/13/2006 6:26:01 PM
RE: Convert txt file to dbf Posted by Geovannie Ariola @ 9/13/2006 6:49:48 PM
RE: Convert txt file to dbf Posted by Ken Murphy @ 9/14/2006 12:57:59 AM
RE: Convert txt file to dbf Posted by tushar @ 9/14/2006 4:16:55 PM
RE: Convert txt file to dbf Posted by NIkhat Hamza @ 9/19/2006 8:55:50 AM
RE: Convert txt file to dbf Posted by Yuri Rubinov @ 9/13/2006 7:31:32 PM
RE: Convert txt file to dbf Posted by Geovannie Ariola @ 9/14/2006 3:22:07 PM
RE: Convert txt file to dbf Posted by Ken Murphy @ 9/14/2006 4:23:07 PM
RE: Convert txt file to dbf Posted by Geovannie Ariola @ 9/16/2006 12:10:44 PM
RE: Convert txt file to dbf Posted by Hari Babu Dornala @ 9/17/2006 7:26:27 PM
RE: Convert txt file to dbf Posted by Norm Braz @ 9/18/2006 4:58:07 PM