Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASCII Parser
Message
From
25/01/2007 13:59:51
Mike Yearwood
Toronto, Ontario, Canada
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01189335
Message ID:
01189344
Views:
9
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform