RE: extracting data from a huge text file (my update on it)

2002-01-28 Thread Sima Lee
Message- From: Andre Turrettini [mailto:[EMAIL PROTECTED]] Sent: Friday, January 25, 2002 3:12 PM To: CF-Talk Subject: RE: extracting data from a huge text file Chris, Sima, Can you keep me posted on what you figure out with that java io buisness. I'll have to do something similar soon

RE: extracting data from a huge text file (my update on it)

2002-01-28 Thread Andre Turrettini
Thanks Sima, Thats some pretty cool functionality. Thanks again for debugging it. I'll look forward to using it. DRE -Original Message- From: Sima Lee [mailto:[EMAIL PROTECTED]] Sent: Monday, January 28, 2002 9:48 AM To: CF-Talk Subject: RE: extracting data from a huge text file (my

RE: extracting data from a huge text file

2002-01-25 Thread Andre Turrettini
This should be IDEAL for you. http://www.macromedia.com/v1/handlers/index.cfm?ID=22277method=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

RE: extracting data from a huge text file

2002-01-25 Thread Shawn Grover
: Chris Giminez [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 6:56 PM To: CF-Talk Subject: Re: extracting data from a huge text file It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris I'm trying to retrieve

Re: extracting data from a huge text file

2002-01-25 Thread Lewis Sellers
On Thu, 24 Jan 2002 23:46:14 -0600, Ron Hornbaker [EMAIL PROTECTED] wrote: okay, min, put DOWN the cough syrup, and step away from the keyboard. You know, if you didn't write such goshdarned excellent code, people would think you were nuts. ;) There is a bee on my keyboard. Ekkk. Oh wait.

Re: extracting data from a huge text file

2002-01-25 Thread Chris Giminez
: extracting data from a huge text file It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris 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

Re: extracting data from a huge text file

2002-01-25 Thread Jim McAtee
, January 25, 2002 10:42 AM Subject: Re: extracting data from a huge text file the format of the text file is not very consistent. It's a comma delimited list, but the last field is itself a comma delimited list and fields 8 and 9 contain one double quote instead of a pair like every other field

Re: extracting data from a huge text file

2002-01-25 Thread Chris Giminez
/handlers/index.cfm?ID=22277method=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

RE: extracting data from a huge text file

2002-01-25 Thread Sima Lee
: 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

RE: extracting data from a huge text file

2002-01-25 Thread Andre Turrettini
]] Sent: Friday, January 25, 2002 11:24 AM To: CF-Talk Subject: RE: extracting data from a huge text file 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

extracting data from a huge text file

2002-01-24 Thread Chris Giminez
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

Re: extracting data from a huge text file

2002-01-24 Thread Don Vawter
what database? - Original Message - From: Chris Giminez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:09 PM Subject: extracting data from a huge text file I'm trying to retrieve data and put it into a database from a text file. The text file

Re: extracting data from a huge text file

2002-01-24 Thread Jim McAtee
a bit more proficient at Perl, just use Perl to read the file and insert the data in the db and be done with it. Jim - Original Message - From: Chris Giminez [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 5:09 PM Subject: extracting data from a huge text

Re: extracting data from a huge text file

2002-01-24 Thread Randy Adkins
would be suitable solution. - Original Message - From: Jim McAtee [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 7:19 PM Subject: Re: extracting data from a huge text file Forget about using CF to read a file that big unless you've got a lot of memory

RE: extracting data from a huge text file

2002-01-24 Thread Tyler M. Fitch
]] Sent: Thursday, January 24, 2002 4:10 PM To: CF-Talk Subject: extracting data from a huge text file 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

Re: extracting data from a huge text file

2002-01-24 Thread Lewis Sellers
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

RE: extracting data from a huge text file

2002-01-24 Thread stas
data from a huge text file 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

Re: extracting data from a huge text file

2002-01-24 Thread Jim McAtee
[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

Re: extracting data from a huge text file

2002-01-24 Thread Chris Giminez
It's called CFX_ReadLine and with an initial test, it looks like it's going to do the trick. thanks very much!! Chris 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

Re: extracting data from a huge text file

2002-01-24 Thread Lewis Sellers
On Thu, 24 Jan 2002 18:10:10 -0700, Jim McAtee [EMAIL PROTECTED] wrote: 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

Re: extracting data from a huge text file

2002-01-24 Thread Jim McAtee
Message - From: Lewis Sellers [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Thursday, January 24, 2002 7:59 PM Subject: Re: extracting data from a huge text file On Thu, 24 Jan 2002 18:10:10 -0700, Jim McAtee [EMAIL PROTECTED] wrote: How does it accomplish this when you want

RE: extracting data from a huge text file

2002-01-24 Thread Ron Hornbaker
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