Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2023, 03:04 PM
Dan99881 Dan99881 is offline Wildcards terms working fine on "find", but I am clueless about "replace" Windows 10 Wildcards terms working fine on "find", but I am clueless about "replace" Office 2013
Novice
Wildcards terms working fine on "find", but I am clueless about "replace"
 
Join Date: Sep 2023
Posts: 2
Dan99881 is on a distinguished road
Default Wildcards terms working fine on "find", but I am clueless about "replace"

Hi,

I'm not sure, but I guess I've sorted it out how to search but not how to replace…

When I search (wildcards enabled) in any particular text from a collection of subtitle texts, both combinations of terms below work out fine (no quotation marks in actual usage):

1) "♪♪ [![]"
2) "[!]] ♪♪"

On the other hand, I can't seem to find the right terms for the "replace" part in order to get the result I want!

I'd like just to keep whatever character MS Word finds as "[![]" unchanged. But I'd need to have the outer ♪ deleted in each case. I am clueless about the way to make it work.

For instance:


If by using "♪♪ [![]" I get "♪♪ A", I just would like to replace it with "♪ A", in other words just delete the outer musical note.

If with "[!]] ♪♪" I find ". ♪♪", I just would like to end up with ". ♪", that is, just delete the outer musical note, now on the other side of the line.

I am excluding "[" and "]" because if any of them are there, then I should not worry about deleting musical notes at all. If they're not, then pairs of musical notes should be avoided. It's not a particularly logical practice, it's more about wanting the files from a collection to look the same.

Thanks in advance!
Reply With Quote
  #2  
Old 09-19-2023, 02:59 AM
gmayor's Avatar
gmayor gmayor is offline Wildcards terms working fine on "find", but I am clueless about "replace" Windows 10 Wildcards terms working fine on "find", but I am clueless about "replace" Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

Search for
♪♪ ([!\]])
Replace with ♪ \1
See Replace using wildcards
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 09-19-2023, 10:16 AM
Dan99881 Dan99881 is offline Wildcards terms working fine on "find", but I am clueless about "replace" Windows 10 Wildcards terms working fine on "find", but I am clueless about "replace" Office 2013
Novice
Wildcards terms working fine on "find", but I am clueless about "replace"
 
Join Date: Sep 2023
Posts: 2
Dan99881 is on a distinguished road
Default

That was just perfect!!!
I already set as a favorite url the "Replace using wildcards" link.
Thank you so much, gmayor!!!
Reply With Quote
Reply

Tags
find & replace, wilodcards



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailto Hyperlink Formula contains too large of "Body" receiving "#Value" need to find workaround MCamera Excel 1 03-02-2022 07:52 PM
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
"Alternation" with Find-n-Replace wildcards? Steve Kunkel Word 2 10-31-2021 06:41 AM
"Find and Replace" tool leaves out many of the occurrences of what I put in the "find" window Swarup Word 8 06-24-2021 08:31 PM
Find and Replace "^&" no longer working merryb Word 3 08-21-2018 04:01 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft