Remove headers from text file

H

Hilton

Hi all,

I have a combined text file made up from 7 individual files. However now I
have 7 headers in my combined file. How do I create a new text file without
the headers? The header line starts with a !.

Thanks
 
K

Kevin B

Since it's only 7 lines I would open the text file in a text editor (Notepad
for instance) and then click EDIT in the menu and select FIND. Enter the "!"
w/o the quotes and click OK

Delete the first header line and then press F3 to locate and delete the next
occurrence. Repeat until all header line have been removed.
 
D

Dave Peterson

Apply Data|Filter|Autofilter (xl2003 menu system) to the column that contains
that indicator.

Then filter by that column to show the rows that contain (or begin with) an
exclamation point.

Delete the visible rows and remove the filter.
 
H

Hilton

HI,


I have about a million records so is there a way to do this
programmatically?
 
Top