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 fil
e this update helps
Regards,
Sima
-Original 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
ECTED]]
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:
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
MAIL PROTECTED]>
> Sent: Friday, 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 fi
acromedia.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 d
" <[EMAIL PROTECTED]>
Sent: Friday, 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
ent: 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
>
>
>
>
>
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
: 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
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 doe
> 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 ht
- Original 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"
> &
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,9
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 contai
llers" <[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
Yes, an MS SQL DTS package, or even the import wizard will get that data
in a blink of an eye. Access will work as well, slower albeit.
-Original Message-
From: Randy Adkins [mailto:[EMAIL PROTECTED]]
You can use Perl or Visual Basic and write an EXE
to handle it.
I had a huge file as
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
Chris,
You're cfhttp-ing to the file so it might not be local to you, but if it
is and if you're on CF5 try to make a dynamic datasource connection to
the .txt file and query it that way.
I don't know the syntax for a .txt cfquery connectstring attribute off
the top of my head - sorry,
t
*
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 fi
Forget about using CF to read a file that big unless you've got a lot of
memory in the server. If CF is your only tool for actually getting the data
into your database, you might use something like Perl to first break the
file up into many smaller files, then run those through CF. If you're a bi
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 f
22 matches
Mail list logo