Hey all, Quick problem. I have a tab-delimeted file and am having some trouble processing it. I was trying to use list functions to loop over the rows (delimited by chr(13) & chr(10)), and then looping over the columns (delimited by chr(9)). I then build a query based on the data (having no problems with the details of query building).
The problem is that in the file, some columns do not have data (see bottom of message for example). CF does not count empty list elements (a,b,,,,,c,d = a list with 4 elements). Anyone have any ideas on this? Sample data: col1 <tab> col2 <tab> col3 <tab> col4 data1 <tab> <tab> data3 <tab> data4 data1 <tab> <tab> data3 <tab> data4 data1 <tab> data2 <tab> <tab> data4 etc... ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
