Search code examples
xmlnotepad++

Notepad++: How to replace a string in the following line when the first string is found in the previous line?

I'm using Notepad++ to edit an XML file, and I'm trying to figure out how to make an edit to multiple records within the file. The problem is, I want to remove a specific string from a following line when I find a different string in the current line. Here's an example:

<id_type>OTHER_ID_1</id_type>
<value>[email protected]</value>

What I'm trying to do is remove @college.edu from the following line whenever I find OTHER_ID_1. I can't do a blanket find/replace of @college.edu, because there are other XML tags in the file that need to have that information.

I've found a lot of code that seems to get me close, but all I seem to be able to do with it is to select it. I've also seen some examples that show how to capture the output in the "Find what:" box, but I can't seem to make it work with the previous examples I'm finding.

This is my current find code:

(?s)(?<=OTHER_ID_1</id_type>)(.+?)(?=</value>)

What's next? How can I remove @college.edu from that selection?

Solution

  • A simple approach would be. Search for

    <id_type>OTHER_ID_1<\/id_type>[^<]+<value>([a-zA-Z0-9.+]*)@college.edu<\/value>

    Replace by

    <id_type>OTHER_ID_1</id_type>\n<value>$1</value>

    Important: Tick the check box that the regular expression also matches newline and carriage return when searching for "."

    Note: The Regex for the name part of the email address is pretty simple :-)