Windows 10: Text Editor with Multiple Search Replace lines

  1.    08 Sep 2015 #1

    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
      My ComputerSystem Spec

  2.    08 Sep 2015 #2

    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.
      My ComputerSystem Spec

  3.    08 Sep 2015 #3

    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
      My ComputerSystem Spec

  4.    09 Sep 2015 #4

    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...
      My ComputerSystem Spec


 

Related Threads
Solved Favorite Basic Text/Data Editor?? in Software and Apps
MS has Notepad as a nice lite text editor and word-pad.. both are nice and fit the need, and pre-installed. But what do you use as a third party tool?? I use the following: Notepad++ Notepad2 Genny EditPad Pro/EditPad lite.. both are great,...
Ever since I installed Windows 10, a lot of text and icons in the search menu are not showing up ever. I've tried the obvious things such as restarting my computer and making sure I have all Windows updates. My start menu and everything else seems...
my setup: win10 with 3 monitors: 4k 27" monitor and two 24" 1920x1080 monitors. windows suggested 150% dpi for the 4k and 100% for the others. 4k looks great but the 24" (with 100% dpi!) looks terrible. The text is all blurry. I saw many...
Solved Windows 10 string text search problem in Performance & Maintenance
I recently updated from 8.1 to 10 and discovered that windows stopped searching inside odt files, in content. It only search in file names. Earlier in 8.1 it worked perfectly fine. I tried to: rebuild index, made sure folder is indexed (it is,...
As it says... I often need to highlight a section of text in a web page and then look it up using Bing. Is this doable ?
Our Sites
Site Links
About Us
Windows 10 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 10" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 14:37.
Find Us