Thread: [Solved] Tricky wildcard search
View Single Post
 
Old 03-13-2014, 11:43 PM
NobodysPerfect NobodysPerfect is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Jan 2014
Location: Germany
Posts: 136
NobodysPerfect is on a distinguished road
Default Tricky wildcard search

Hi,

I just read Paul's answer to a wildcard Seach & Replace issue https://www.msofficeforums.com/word-...ve-spaces.html, which led me to one of my 'Search & Replace using wildcards' questions.

I need to find a "*" within a string (possible) followed by any charcater or digit (possible) within table cells (table cell marker as 'delimiter'). The string after the "*" has to be deleted (replace "*", possible ).

The problem is not the first part of the pattern, but the restriction to a table cell. I tried '^7' as well as 'Chr(7)', but both don't work.

Right now I'm using a VBA procedure, but simple Search & Replace would be much better - in this specific case.

Thanks
NP
Reply With Quote