Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-14-2018, 05:41 PM
Peterson Peterson is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2017
Posts: 19
Peterson is on a distinguished road
Default Wildcard search once worked, now does not

I need to take a list of phrases with parentheticals next to them and swap their order so that the parenthetical is first, the phrase second, and while stripping the parentheses (and other similar punctuation). I've developed the following find/replace string that I SWEAR I've successfully used multiple times in the past but which is now no longer working. Instead of swapping the first found string and moving to the next one, which is on the following line, the search increments on that first line by just a single character in the first string, then continues swapping, which ain't right.



I ran a macro to reset the wildcard search, restarted Word, to no avail. Is my memory going, or did I fat-finger the find/replace strings?

Here they are, plus a short sample of the text I'm working with:

Find:
(*)( )([\(\[])(*)([\)\];])(^13)

Replace:
\4^t\1\6

Sample list:
Endangered Species Act (ESA)
linear feet (lf)
Federal Emergency Management Agency (FEMA;
river miles [RM]
North American Vertical Datum of 1988 [NAVD88]
right-of-way (ROW)

To be clear, the first find is:

Endangered Species Act (ESA)[paragraph mark]

The first replace is:

ESA[tab]Endangered Species Act

the second find should be linear feet (lf) but it's not; it's this:

SA[tab]Endangered Species Act[paragraph mark]

linear feet (lf)[paragraph mark]
Reply With Quote
  #2  
Old 09-14-2018, 07:09 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,249
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

Your wildcard Find/Replace works just fine for me, though it could be simplified to:
Find = (*) [\(\[](*)[\)\];]^13
Replace = \2^t\1^p
Are you sure you don't have 'Tracked Changes' on?
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 09-17-2018, 07:17 AM
Peterson Peterson is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2017
Posts: 19
Peterson is on a distinguished road
Default

Thanks for trying it out, and for the streamlining -- don't know why, but I just assumed that every substring needed to be in parens.

I tried running it again this morning after restarting my computer, and it still doesn't work. Had a coworker try it and, as with you, it worked fine for them, so it looks like I'm going to need to repair Office. Track changes is off on my machine; there's nothing hidden,etc.


EDIT: I had to re-install Office to fix the problem...
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having problems with a Wildcard search Cosmo Word VBA 9 02-12-2016 08:03 PM
Issue with wildcard search mysterytramp Word 0 05-13-2015 10:40 AM
Where is the error in my wildcard search? Ulodesk Word 10 06-30-2014 01:46 PM
Tricky wildcard search NobodysPerfect Word 10 03-19-2014 04:29 AM
Wildcard search help. Kempston Word 0 11-13-2009 03:58 AM


All times are GMT -7. The time now is 03:53 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft