Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Importing wide(?) files
Message
 
 
To
11/08/1998 16:50:11
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00125780
Message ID:
00125785
Views:
17
Bruce,

Did you choose to split the file? VFP should be able to import the whole thing at once provided you don't have too many fields. If you have to put the two files back together I'd do something like:

create cursor awide ( struct of first half, using same field names as real table )
append from TheWideFile type delimited
create cursor bnarrow ( struct of second half )
append from TheNarrowFile type delimited
select awide
scan
scatter memvar
select bnarrow
scatter memvar
skip 1 in bnarrow
select RealTable
append blank
gather memvar
select awide
endscan

>OK - so my mind is turning to mush. I have a wide file - about 730 characters wide - that I need to import. It will be in ASCII delimited format. I have divided it into two files of about 480 characters and 240 characters. What is the easiest way to get them into a VFP 5 table. I can APPEND FROM for the first one but then how do I get the rest of the fields from the second file into the proper records. I know which fields are where. Suggested approaches please.
>TIA
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform