Replace text strings with VBA

Hi,
I have a 200 page server list containing text similar to that below. I need
to delete the text between the last asterisk after "Version" up to the phrase
"Exclude Lists"
I have looked all over but no joy. Can anyone help?
thanks,
Ross
**********************************************************
Host:w2kserver
Operating System:Windows2000 5
Machine Type:Windows
Host Type:Client
Version:5.1
**********************************************************
Universal Settings

Restore retries: 0
Browse timeframe for restores 0 days
Required network interface

Exclude Lists

Greg
Fri Feb 17 10:56:02 CST 2006

Ross,

You don't really need VBA for this. You can do it with a wildcard
search and replace.

Find: (\*[1,})*(Exclude List)

Replace with \1^13\2

Klaus
Fri Feb 17 14:14:09 CST 2006

"Greg" <gmaxey@mvps.org> wrote:
> Ross,
>
> You don't really need VBA for this. You can do it with a wildcard
> search and replace.
>
> Find: (\*[1,})*(Exclude List)
>
> Replace with \1^13\2


Hi Greg, Ross,

There's a typo -- [ instead of { -- and the * wildcard is pretty dangerous
(it will match everything from the first asterisks it encounters onward).
Also, ^13 should better not be used in "Replace with" (because it won't put
in a real paragraph mark).

Better, I think:
Find what: (\*)[!\*]@(Exclude List)
Replace with: \1^p\2

Hope this will do the trick,
Klaus

Greg
Fri Feb 17 14:52:05 CST 2006

Klaus,

Thanks for the backup. WRT the the ^13, I should have known that as I
have a tips page on that very topic ;-(

http://gregmaxey.mvps.org/Replace_With_Paragraph.htm

Klaus
Fri Feb 17 15:02:52 CST 2006

Greg wrote:
> Thanks for the backup. WRT the the ^13, I should have known
> that as I have a tips page on that very topic ;-(
>
> http://gregmaxey.mvps.org/Replace_With_Paragraph.htm

<g> ... Nice!! Hadn't seen that yet.

Klaus

Ross
Mon Feb 20 04:21:26 CST 2006

Many thanks for your assistance, this has opened up an incredibly useful set
of tools.
Ross

"Klaus Linke" wrote:

> Greg wrote:
> > Thanks for the backup. WRT the the ^13, I should have known
> > that as I have a tips page on that very topic ;-(
> >
> > http://gregmaxey.mvps.org/Replace_With_Paragraph.htm
>
> <g> ... Nice!! Hadn't seen that yet.
>
> Klaus
>
>
>

Ross
Mon Feb 20 04:21:29 CST 2006

Many thanks for your assistance, this has opened up an incredibly useful set
of tools.
Ross


"Klaus Linke" wrote:

> Greg wrote:
> > Thanks for the backup. WRT the the ^13, I should have known
> > that as I have a tips page on that very topic ;-(
> >
> > http://gregmaxey.mvps.org/Replace_With_Paragraph.htm
>
> <g> ... Nice!! Hadn't seen that yet.
>
> Klaus
>
>
>