Re: Tab Delimited file question

2002-08-15 Thread Jochem van Dieten
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

RE: Tab Delimited file question

2002-08-15 Thread C. Hatton Humphrey
In my case I can't... one of the things that I'm trying to do with the tool is have it check the number of columns versus the number of required columns. Hatton > -Original Message- > From: Nick McClure [mailto:[EMAIL PROTECTED]] > You need to use the first row as the column headings. Th

RE: Tab Delimited file question

2002-08-14 Thread Nick McClure
ursday, 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.

RE: Tab Delimited file question

2002-08-14 Thread Timothy Heald
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

RE: Tab Delimited file question

2002-08-14 Thread Nick McClure
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 c

RE: Tab Delimited file question

2002-08-14 Thread C. Hatton Humphrey
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 som

RE: Tab Delimited file question

2002-08-14 Thread Timothy Heald
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:/