You might still use the Merant ODBC text driver to do the work of retrieving the lines, though. Just treat it as a single large field and continue to parse it as you're doing.
Jim ----- Original Message ----- From: "Chris Giminez" <[EMAIL PROTECTED]> To: "CF-Talk" <[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 one double quote instead of a pair like > every other field. It's very strange and I can't get the writers of this text file to explain their > logic or change it so far. > I don't think an automated solution will work for these reason, so I am parsing each line piece by > piece and saving as individual variables. > > > > Another option.. Why not open it as an ODBC data source, and let the > > ODBC > > drivers worry about the size of the file? We recently did something > > like > > this with VB for a text file, only a few lines/records though. But it > > should still work well with larger files. ______________________________________________________________________ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
