Cleaning up an imported txt file

**yzer19** · 11-16-2007, 10:19 AM

I have a txt file that I want to import into excel. The problem is the file comes thru with headers, footers, page numbers etc. The end result is to have the data in a nice clean list showing only the "V.I.N." column and the "ship dte" column. The code below imports the data and deletes the unwanted columns. As you can see from the report there is 2 columns of VIN and ship dte on the report

HTML Code:

The next step is were I'm lost. How do I get columns C and D to move under A and B and then get rid of the excess page numbers, headers etc.
A few points (in case it helps)
-The VIN number will always be 17 digits long.
-The report length will vary each week the report is run.
The end result would be 2 have all the VIN's in column A and the ship dte in column B.

Thanks
Rob

**mikerickson** · 11-16-2007, 11:40 AM

Those looked like live VIN's in your attachment, so I spiked the attachment.
If you repost the attachment with pseudo-data it will give internet search robots less to chew on.
If you post a copy of what you want your Excel sheet to look like, it would help the folks here supply an answer to your question.

**yzer19** · 11-16-2007, 12:32 PM

Thanks for the tip. I scrambled the VINS on the original post but I have changed this now to be xxxxxxxxxx. How can I attach a excel file, do I need to zip it?

**mikerickson** · 11-16-2007, 02:00 PM

Thanks.
Yes, Excel files need to be zipped. Also, if you are using 2007, saving and posting your file in an earlier format increases the number of people who can look at the fie.