There use to be a CFTag in the Exchange that would do that for you. Look for Tab Delimited files or something like that. I used one before but don't recall the name.
---------- Original Message ---------------------------------- from: "David Schmidt" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Tue, 26 Mar 2002 12:08:16 -0800 >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
