Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reading a CSV file into an array
Message
From
30/11/2001 03:31:28
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
29/11/2001 15:49:17
John Marrone
Bloodstock Research Inc.
Lexington, Kentucky, United States
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00587527
Message ID:
00587869
Views:
36
>Hi Cetin
> Thanks for the help. I will keep it in mind. I really want to read it
>into an array. But if all else fails I understand your way and may have to do it that way. Hope not. Thanks again!
>
>John Marrone
>jmarrone@brisnet.com

John,
I said array wouldn't work (at least at one pass) based on your givings :
1500 fields per line and 500K file. I guessed it was more than 43 lines (65000/1500 roughly).
It'd take a few seconds to do that way (not coding wise) IMHO.
PS: Another approach :
You could stuff every 250th occurence of comma with chr(13)+chr(10) to get a 250 fields delimited file (threaten first 6 header lines as separate).
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