Replace text strings with VBA

[Ross]

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]

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 Linke]

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]

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 Linke]

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]

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

 

[Ross]

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