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

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.
--
Kevin Backmann


"Hilton" wrote:

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

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.

Hilton wrote:

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

--

Dave Peterson

HI,


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

"Dave Peterson" wrote in message
...
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.

Hilton wrote:

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

--

Dave Peterson

Record a macro when you do it manually and you'll have the code.

Hilton wrote:

HI,

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

"Dave Peterson" wrote in message
...
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.

Hilton wrote:

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

--

Dave Peterson

--

Dave Peterson