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 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
