Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ASCII Parser
Message
De
25/01/2007 13:59:51
Mike Yearwood
Toronto, Ontario, Canada
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Divers
Thread ID:
01189335
Message ID:
01189344
Vues:
10
>Hi,
>
>I was wondering if anyone has a program/code to parse ASCII Delimited and/or Fixed text into a dbf and back. I need to integrate this functionality into my app and it would save alot of time if someone has already coded this. Thanks in advance.

I'm going to assume you know all about the append command, or you wouldn't be able to build much of an app. :)

I can't just give you the code as it requires Visual MaxFrame Professional. However, what the code does is provide the users with a mover containing all the fields in one of my system's tables.

The user moves the fields from the left list box into the right box in the same sequence as the fields' data exists in the ascii file.

I even added a button to insert a blank field into the righthand listbox.

Then I use the right hand listbox contents to create a cursor. Then I append from the ascii file into that cursor.

I then display to the user what incoming data matched any existing data. http://foxridgesoftware.com/Software/ScreenDesigns/DataMatcher/tabid/61/Default.aspx

Then I update existing records from that cursor and append non-matching records from that cursor into the table in my system.

HTH
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform