Now that I think about it, your right, It won't help because CF treats the multiples as one when you do some of that stuff.
here is an idea, replace TABTAB with TAB|TAB then you can use the | to separate the duplicate column, in your insert statement just add an if statement, I know it is not the most efficient way, but it is late and it is the best I can come up with. At 12:24 AM 8/15/2002 -0400, you wrote: >I am not (currently) using dts to import this. That is the only place (well >and in access) I have even ever noticed it. How do the column names help >me? > >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: Nick McClure [mailto:[EMAIL PROTECTED]] >Sent: Thursday, August 15, 2002 12:33 AM >To: CF-Community >Subject: RE: Tab Delimited file question > > >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 > > > > > > > > ______________________________________________________________________ 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
