Apps :: Text Editor With Multiple Search Replace Lines

I am looking for a text editor which will allow me to take multiple lines from one text file (I also have the information in a spreadsheet) and will then replace then lines in another line of that document.

I am trying to make a list for my books and comics.

<Book Series="{name}" Number="{no.}" Volume="{year}" </Book>
<Book Series="{name}" Number="{no.}" Volume="{year}" </Book>

For the comics it would need to replace the above format so;

<Book Series="{Batman}" Number="{01}" Volume="{2011}" </Book>