Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Obnoxiously large text file
Message
De
07/02/2008 16:11:12
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01290411
Message ID:
01290596
Vues:
12
>I am working for a large company that recently merged with another large company. They were both storing data in very large text files. In some ultimate wisdom due to the merger the result is that the data will be combined into an even larger text file with a record length of 78,000+. Considering tha the VFP maximum record length for text files is 65535, does anyone have any suggestions as to how I could read such a file and use it in VFP? The current recod length is approx. half that. All I do with this file is open it and remove certain pieces of it into a table for processing. Any ideas?
>
>Thank You!

How many bytes is "Obnoxious"?
In any case you'd have problems with that file. If file size is less than 2Gb then you have a chance to do that with lowlevel functions. Do not use fgets() but fread() to read (documented but still is a bug IMHO).
78000 bytes is above a record's allowed size. You may need to parse parts of it into memo fields.
SQL server express is for free and I think it is worth to get help from SQL server for doing the transfer.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform