Do a replace in the file for consecutive delimiters and change them to something like ,'',
----- Original Message ----- From: David Schmidt <[EMAIL PROTECTED]> Date: Tuesday, March 26, 2002 1:08 pm Subject: reading tab-delimited files. > 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... > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
