Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Importing wide(?) files
Message
 
 
À
11/08/1998 16:50:11
Bruce Gilmour
Cal-Mour Consultants
Calgary, Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00125780
Message ID:
00125785
Vues:
18
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform