How do I replace some text?

Alan Kilborn

Most of your 17 posts start with “How do I replace…”.
This is not a data manipulation service.
At this point we ask you to supply what you have tried on your data, in order to receive further help.

Scott Nielson

@Alan-Kilborn I thought I had explained it.
In the RegEx mode, I checked the “Match case”, put (?s)^\s*Note:.+([^<)*)(?=) in the “find” field and Note: Wherever it is found, "<" denotes aggravation \(worse by\), ">" denotes amelioration \(better by\), "<->" denotes alternates with and A/F is an abbreviation of, "Ailments from" in the “Replace” field but it didn’t do nothing.

When I put (?s)\s*Note:.+([^<)*)(?=) in the “find” field, half the files are found but not all.

Scott Nielson

@Alan-Kilborn When I put (?s)\s*Note:.+([^<)*)(?=) in the “find” field, half the files (out of multiple files) with that text are found but not all, besides it replaces everything till the last  in each file is found but I want it to stop searching beyond the first occurrence of 

Scott Nielson

@Alan-Kilborn If I use (?=Note)([^<)*) in the “find” field, only half that text is found, that is till it reaches the first <

Scott Nielson

@Alan-Kilborn If I use (?:<)(*SKIP)(*FAIL)|(Note.+) in the “find” field, everything except the is matched (which anyway is not needed if I skip that in the “replace” field also) but it only replaces that text in 70 out of 150 files. Something is wrong and I need help!

Scott Nielson

@Alan-Kilborn OK, I got it - the other 80 files had a   tag at the end and when I used that instead of the  tag at the end, I was able to find and replace the text in the other 80 files also. Thanks a million anyway.

Alan Kilborn

Sorry, I didn’t notice that you had supplied what you tried.
And in the interim it appears that you solved the problem yourself.
This is good.

Scott Nielson

@Alan-Kilborn or anyone else, The text that I aked to help with (what I’ve posted right on top) has been replaced with some HTML code in between and is now like:-

Note:
Wherever it is found, &quot;&lt;&quot; denotes aggravation (worse by),
&quot;&gt;&quot; denotes amelioration (better by), </span><span lang=EN-US
style='font-size:13.5pt;line-height:115%;font-family:"Verdana","sans-serif";
color:black;mso-themecolor:text1'>&quot;</span><span style='font-size:13.5pt;
line-height:115%;font-family:"Verdana","sans-serif";mso-fareast-font-family:
"Times New Roman";mso-bidi-font-family:"Times New Roman";color:black;
mso-ansi-language:EN-US'>&lt;-&gt;</span><span lang=EN-US style='font-size:
13.5pt;line-height:115%;font-family:"Verdana","sans-serif";color:black;
mso-themecolor:text1'>&quot;</span><span style='font-size:13.5pt;line-height:
115%;font-family:"Verdana","sans-serif";mso-fareast-font-family:"Times New Roman";
mso-bidi-font-family:"Times New Roman";color:black;mso-ansi-language:EN-US'>
denotes alternates with and A/F is an abbreviation of, &quot;Ailments from&quot;</span><span
lang=EN-US style='font-size:13.5pt;line-height:115%;font-family:"Verdana","sans-serif";
color:black;mso-themecolor:text1'><o:p></o:p></span></p>

I wanted to replace that with something else again but the above RegEx, (?:<)(*SKIP)(*FAIL)|(Note.+) doesn’t find it anymore. Please tell me how to find this new text now. Thanks in advance for the help!

Scott Nielson

@Alan-Kilborn This RegEx, (?s)(?<=Note).*?(?=) finds what I want it to but is it correct as a RegEx?

Alan Kilborn

@Scott-Nielson said in How do I replace some text?:

but is it correct as a RegEx?

Sure looks correct.

Scott Nielson

@Alan-Kilborn OK, thanks a lot! Hasta la vista.