Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading select fields from ASCII delim file and update r
Message
From
27/03/2000 22:46:32
 
 
To
27/03/2000 22:41:32
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00351198
Message ID:
00351201
Views:
17
Peter,

>I need to add/update records in a table with certain field information from an ASCII text deliminated
>file. How do I open, access certain fields, and process records. For information, out of approximately
>30 columns in the ASCII file, I need about 5.

You will first open an intermediate table defined with fields in the order they are in the source file, at least as many as needed to cover up to the 5 you need. Or just define all 30. Then
APPEND FROM sourcefile TYPE DELIMITED
Then you can index that file if necessary and extract just the fields you need from it to update your master table.
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform