Selecting text between two key phrases

macropod · #1 06-24-2012, 04:50 PM

You can do it with or without vba, using a wildcard Find/Replace, where:
Find = "MORE INFO ABOUT THE ITEM*ITEM NUM : "
Replace = ""

Chayes · #2 06-24-2012, 05:40 PM

Hi

Ok thanks.

I gave it a go using search replace , and unfortunately it doesn't find the string. I'm not sure why.

This is what I'm running :

Code:

    Selection.Find.ClearFormatting
    Selection.Find.Replacement.ClearFormatting
    With Selection.Find
        .Text = "MORE INFO ABOUT THE ITEM*ITEM NUM : "
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindContinue
        .Format = False
        .MatchCase = False
        .MatchWholeWord = False
        .MatchAllWordForms = False
        .MatchSoundsLike = False
        .MatchWildcards = True
    End With
    Selection.Find.Execute Replace:=wdReplaceAll
    Selection.Find.Execute
    Selection.Find.Execute Replace:=wdReplaceAll

This is a section of the text I'm trying to affect ;

Item Format UP € - EUR Qty Availability
Item num : 112027bx41
Bowie - Jagger - Dancing In The Street - 12 inch 45 rpm - EX/EX
more info about the item [ Inventory : 0 ] 12 inch 45 rpm 5.95 1 Available

Item num : 25093bx180
Jagger Mick - Let's Work - 7inch (SP) x 2 - EX/EX
more info about the item [ Inventory : 0 ] 7inch (SP) x 2 2.95 1 Available

Item num : 116699bx102
Jagger Mick - Just Another Night - 7inch (SP) x 2 - NA/EX
more info about the item [ Inventory : 0 ]

I can't see why this wouldn't find the sections in the Find/Replace dialogue...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Question about selecting text w/mouse	Jazz43	Word	3	11-29-2011 11:58 PM
Selecting styled text	Caroline	Word	5	02-15-2011 12:55 PM
Automatically Hyperlink phrases	TinaIgnatiev	Word	1	12-22-2010 01:42 PM
Selecting specific text out of a series of columns	speedycorn1	Word	3	11-01-2010 02:58 PM
Selecting a Text Box	gajesh	Word	0	09-02-2009 11:45 PM