different line lengths in tab delimited file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a tab delimited file that has 46 fields in the header row.
The last three fields are only populated in some cases, so there should be 3
tabs at the end of each line after the word "FALSE/TRUE" (which is in field
number 43). What I am finding is that after the 16th record the file
sometimes has 0,1 or 3 tabs causing programming to fall over.
I can fix the issue by opening in excel and adding a field that is populated
throughout the file, but would like to know how it has happened in the first
place.

I believe this file comes out of an Access database
 
Hi Desperate,

I've never heard of Access's standard export routine doing this.

On Thu, 9 Jun 2005 07:37:02 -0700, "desperate dan" <desperate
 
Back
Top