You need to use the first row as the column headings. That will help you some.
At 12:15 AM 8/15/2002 -0400, you wrote: >Well that got us closer to the answer. There are supposed to be 55 columns. >I get 46 or 48 after the replace. Suggestions? > >Is there a way to get excel to list numbers as column headers instead of >letters? > >Timothy Heald >ACP/CCFD :) >910-425-9988 > >Manager Fayetteville ColdFusion User Group >http://www.fcfug.org > >Fusebox Advisory Committee Member >http://www.fusebox.org > > >-----Original Message----- >From: Timothy Heald [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 15, 2002 12:11 AM >To: CF-Community >Subject: Tab Delimited file question > > >Hey, > Ok so I am looping through this tab delimited file to write it in a SQL >DB. Rows are no problem. Problem is in the columns. There are many empty >columns, and as such two tabs right next to each other. So my lengths come >out all wring, and when I try and use list functions I exceed the index. > > Ideally I would like to use listToArray, and just be able to call the >values that way. Nice, easy, logical. Any suggestions? hmm guess I could >do a replace() all #chr(9)##chr(9)# with #chr(9)# #chr(9)# or some such. >Off to try it :) > >Timothy Heald >ACP/CCFD :) >910-425-9988 > >Manager Fayetteville ColdFusion User Group >http://www.fcfug.org > >Fusebox Advisory Committee Member >http://www.fusebox.org > > > ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
