Replacing Specific Text In String Only

indi visual

New Member
Joined
Oct 15, 2010
Messages
22
*you may want to turn word wrap off in notepad to get a full view of the lines*

With these lines, I'm trying to figure out a way to replace "(Keyword problematic value.me)" on all lines to "(KeyWord problematic valueReserveDotMarkerme)".

Basically replacing the dot with "ReserveDotMarker", but only if it is contained in "(KeyWord...*)

http://www.iandmyself.me/replacing-specific-values-strings.txt


As you can see, they're already changed on the left, but not the right.

In addition, the tricky part is that "iandmyself.me" has the same ".me" value in it (I plan to leave these unchanged).

All the words you see in the lines are random generic phrases:
I will not know what any of these values actually are except ".me" and "(KeyWord "

Also, the only other definitive I have is that all of the "iandmyself.me" (links) will not have spaces.

I'm not worried about the trailing fragment dashes and underscores, I just need to mark the "(KeyWord problematic value.me)"s on the right side.
 
Last edited:

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Forum statistics

Threads
1,216,109
Messages
6,128,875
Members
449,476
Latest member
pranjal9

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top