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... This is a list of photos with a description of each photo. There is a tab between the photo filename and the description, then a return...chr(10)&chr(13)...at the end of each pair. I've tried several methods to get this code into an array with the filename as the first array element and the description as the second array element, but so far it's not working. I read the file with this code: <cffile action = "read" file = "e:\active_photos.txt" variable = "active_photos" /> >From here, I've tried listtoarray, etc., but I can't get the info in the text file into an array properly. I can use listtoarray with chr(10)&chr(13) as the delimiters, but that gives me each row as an element. I can't figure out how to use both delimiters to parse the rows and the row elements. I was using the MySQL function, "load data infile," to load the data into a table, but some of the text files have blank lines, like the <enter> key was struck a couple of times, and that throws an error with load data infile. Suggestions? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:312789 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4