I'm looking for the answer to this issue as well... I've tried the replace, it doesn't work.
If you figure something out let me know too :) I'm trying to build a "generic" file test tool as to company I work for has several products and clients that use TSV imports and they're always mucking something up. Hatton > -----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
