different line lengths in tab delimited file

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
 
J

John Nurick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tab Delimited Issue 3
Export to Tab delimited text file 4
Export Delimited 1
Export Date without Time to text tab delimited file 3
Tab-delimited *.txt file linking; text into numbers 1
ADP Import Tab Delimited File 1
Access 97 Query to a tab delimited file 3
Import a dbf or a tab delimited file 1

Top