I have a 17.5Mb text file made up of 128,000 lines, each line being an individual record to be imported into a database. When I open the file and input each line using the 'Line Input' command I can only retrive the first 40,000, from then on each line inputed is blank. Can anyone help!!!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Retreiving data from large files 1
- Thread starter ejgb
- Start date
-
1
- #2
Hi,
I deal with much larger files on a daily basis (several hundred Mb) and never had any problems with line input. The problem must be somewhere else in the program. Make sure that you use a long (not an integer) to count your lines etc.
Another thing is that line input is easy to use, but very slow compared to reading large chucks (open for binary) or using the API to read the file.
Sunaj
I deal with much larger files on a daily basis (several hundred Mb) and never had any problems with line input. The problem must be somewhere else in the program. Make sure that you use a long (not an integer) to count your lines etc.
Another thing is that line input is easy to use, but very slow compared to reading large chucks (open for binary) or using the API to read the file.
Sunaj
- Thread starter
- #3
MichaelRed
Programmer
ejgb, read THE REST of her post!
Unless you are being paid by the CPU cycles used, importing "large" files via Line Input is quite counter productive!!!!!
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
Unless you are being paid by the CPU cycles used, importing "large" files via Line Input is quite counter productive!!!!!
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
MichaelRed
Programmer
Sunaj,
I was not refering to you/your post. Your response was 'fine'. It responded DIRECTLY to the question asked and provided an appropiate fix to the problem as stated. You even went on to offer additional -and appropiate- counsel. It was the alst part which was (aparently) overlooked by "ejgb".
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
I was not refering to you/your post. Your response was 'fine'. It responded DIRECTLY to the question asked and provided an appropiate fix to the problem as stated. You even went on to offer additional -and appropiate- counsel. It was the alst part which was (aparently) overlooked by "ejgb".
MichaelRed
m.red@att.net
There is never time to do it right but there is always time to do it over
- Status
