Text Editor with Multiple Search Replace lines

Hello All

I am looking for a text editor which will allow me to take multiple lines from one text file (if it helps 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>

Any suggestions would be great

Thanks

Hi and welcome!

Notepad++ is a very good text editor and it also supports doing search and replace actions based on regular expressions.

The exact regular expression, which you can use will depend on how exactly the input looks like, e.g. how the different entries are separated.

So if i used my excel file and the expressions were listed under different headings the search and replace function should be able to grab the entries from each column

In text files you do not have columns; if you want to do this with a text editor, then columns cannot be used directly. However, I think you should be able to convert your spreadsheet into something else, e.g. into a comma-separated list or into something where you have tabs between the different entries like so:

Batman,01,2011
Batman\t01\t2011

With that you should be able to grab the different values...