Hi, I have had it complied but have not try it out yet. If you want please contact me off list, because I cannot attach any file here.
Regards, Sima -----Original Message----- From: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 12:54 PM To: CF-Talk Subject: Re: extracting data from a huge text file It does look ideal. Unfortunately, I'm not sure how to plug in and compile the Java code and don't know that I can take the time to learn just now. Anyone have the class files for this that can be plugged in ready to roll? Chris > This should be IDEAL for you. > http://www.macromedia.com/v1/handlers/index.cfm?ID=22277&method=full > > DRE > > -----Original Message----- > From: Jim McAtee [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 24, 2002 6:10 PM > To: CF-Talk > Subject: Re: extracting data from a huge text file > > > 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