1. Joined : Sep 2015
    Posts : 2
    Windows 10 Home
       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 System SpecsSystem Spec


  2. Joined : Aug 2015
    Posts : 610
    W10
       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 System SpecsSystem Spec


  3. Joined : Sep 2015
    Posts : 2
    Windows 10 Home
       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 System SpecsSystem Spec


  4. Joined : Aug 2015
    Posts : 610
    W10
       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 System SpecsSystem Spec


 


Similar Threads
Thread Forum
Solved Favorite Basic Text/Data Editor??
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,...
Software and Apps
Some icons and text not showing in search menu
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...
General Support
Multiple screens of different dpi show blurry text (really bad)
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...
General Support
Solved Windows 10 string text search problem
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,...
Performance & Maintenance
Spartan. I'm missing ability to highlight page text to search via Bing
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 ?
Browsers and Email
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 19:26.
Find Us
Twitter Facebook Google+



Windows 10 Forums