Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Obnoxiously large text file
Message
From
07/02/2008 16:11:12
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01290411
Message ID:
01290596
Views:
13
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform