Timothy Heald wrote: > 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.
That will work, but only if you do the replace twice to catch the cases where there are more as 2 consecutive empty columns. If possible, replace the tabs by comma's with a space on both sides, then use cfhttp on it and you will get a nice query of it. Won't work if the data already contains commas. Jochem ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists