How does it accomplish this when you want to loop over the contents of a large file? Does it keep the file open, or when you call it to read the 250,000th line, has it opened and closed and read through the file 249,999 times already?
Jim ----- Original Message ----- From: "Lewis Sellers" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, January 24, 2002 5:54 PM Subject: Re: extracting data from a huge text file > On Thu, 24 Jan 2002 16:09:54 -0800, "Chris Giminez" > <[EMAIL PROTECTED]> wrote: > > >I'm trying to retrieve data and put it into a database from a text file. > >The text file is over 100MB with (I'm guessing) around 260,000 records, each record contains 85 > >fields. > > > >I tried to create a conditional loop at each line break, which works fine if I am working on a > >smaller version of the file, but chokes on the 100MB monster. Is there a more efficient way to deal > >with this other than looping through it or is there a way to break this file up into smaller chunks > >and deal with it piece by piece? > > > Been a while since I used it but I wrote a cfx called... hmm.. I don't > recall what it was called /-) ... anyway, the cfx was to read in log > files one line at a time. > > Which is what it does, one carriage-deliminated line per call, not the > entire file all at once. > > It's somewhere at http://www.intrafoundation.com/freeware.html. > > --min > ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists