Hi Rick, depending on how large the text file is, you might consider using the gnu texttools (sed, awk, grep etc.) to convert the data to sql statements and import the result natively via mysql. This is WAY faster than parsing it via cf, as text file parsing is one of the things cf is *really* weak at (sadly).
as far as the cf part is concerned: you can use two loops for that. one to loop over the list of elements divided by line breaks (13/10), one inner loop that uses chr#9 as delimiter. bye, marcus Rick Faircloth schrieb: > Hi, all... > > I've got a text file that I'm trying to read with cffile that has > data structured like this: > > 96201_01.jpg Main View > 96202_01.jpg Alternate View 01 > etc... > > -- Mit freundlichen Grüßen, Marcus Raphelt at.net websolutions Mühlenbeck & Raphelt GbR Klever Str. 60 47839 Krefeld Tel.: 02151 / 3699732 Fax : 02151 / 3699734 Mob.: 0151 / 58113803 mailto: [EMAIL PROTECTED] http://www.atnet-websolutions.de ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312795 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
