Re: Parsing through text file

2006-01-11 Thread Pete Ruckelshaus
Been there, done that, don't want to do it again. I worked on an app that allowed a site admin to upload a .csv file with updated store data (from his POS system). I found a UDF at cflib.org that turned a .csv file into a query object, and I looped through that. However, on a fast machine (my wo

Re: Parsing through text file

2006-01-11 Thread Massimo Foti
This UDF read a strig line by line and turn it into an array leveraging Java's API (no CFML lists). Not sure if it may fits your neds: http://www.cflib.org/udf.cfm?ID=1222 Massimo Foti Tools for ColdFusion and Dreamweaver developers: http://www.massimocorner.com

Re: Parsing through text file

2006-01-11 Thread Jim Wright
What database? If it is SQL Server, you may be able to set the import up as a DTS package, and then fire off the DTS package when the new file is uploaded. -jim On 1/11/06, Robert Everland III <[EMAIL PROTECTED]> wrote: > We have a file upload process here where a user needs to upload a file, the

RE: Parsing through text file

2006-01-11 Thread Munson, Jacob
efficient text processing. > -Original Message- > From: Figy, Kam [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 11, 2006 9:02 AM > To: CF-Talk > Subject: RE: Parsing through text file > > List functions are really slow. I'll bet you could realize a >

RE: Parsing through text file

2006-01-11 Thread Figy, Kam
List functions are really slow. I'll bet you could realize a pretty good speed increase using ListToArray() first and parsing the array, since you're iterating over it so many times. Hth Kam -Original Message- From: Robert Everland III [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 1

Re: Parsing through text file

2006-01-11 Thread Claude Schneegans
>>The issue is the processor goes crazy on a 1.4 mb file. There are no line breaks. Just a 1.4 mb string of text that is delimenated. 1.4 mb is not that long for processors we have nowadays. Is your server so small? The problem might be reading the file as a list and using listGetAt(), which i

Re: Parsing through text file

2006-01-11 Thread Robert Everland III
The issue is the processor goes crazy on a 1.4 mb file. There are no line breaks. Just a 1.4 mb string of text that is delimenated. I'm trying to parse through it in Homesite and it's killing the processor on there also. I guess there isn't much I can do. Bob ~

RE: Parsing through text file

2006-01-11 Thread Justin D. Scott
> We have a file upload process here where a user needs to > upload a file, the file then needs to be parsed through to > get data out of it and inserted into a database. The file is > 1.4mb long. I'm having issues just reading and looping > through the file. Is there a better way to do somethi