Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    Find & Replace w/multiple instances? (using a conversion file)

    Help wanted · · · – – – · · ·
    2
    3
    1842
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Perry Sticca
      Perry Sticca last edited by Perry Sticca

      Hello from California - I have a large text file, full of financial data, with hundreds of 6-digit account numbers scattered throughout the file. We are converting to a new 7-digit format, and I have a file that shows, one line at a time, each old 6-digit number, and the new 7-digit number that it converts to.

      I’d like to “feed” this conversion table to Notepad++, and tell it to take my huge financial file and perform a “find and replace all” routine multiple times, replacing each 6-digit number with its new 7-digit number, and then moving down to the next line of the conversion file and repeating the process.

      If I have to, I can move both files to Excel and perform a VLookup, but I’d rather stay in the Notepad++ 7.3.3 world. Does anyone know a way to get this done?

      1 Reply Last reply Reply Quote 0
      • Perry Sticca
        Perry Sticca last edited by

        ======= E D I T ==============

        After more than a month of many views, but no replies, I asked the same question in another thread that was discussing a similar issue.
        Fortunately, a very helpful community member guy038 was able to come up with a solution for me and posted it, so anyone interested can view the discussion at:

        https://notepad-plus-plus.org/community/topic/14548/help-replacing

        Scott Sumner 1 Reply Last reply Reply Quote 0
        • Scott Sumner
          Scott Sumner @Perry Sticca last edited by

          @Perry-Sticca

          I think the fact that you didn’t give any example data in this thread, but you did in that other thread, had something to do with your lack of replies (data is power!). It happens a lot here where people just throw out a bunch of vague thoughts and hope people can read their minds and provide answers. I’m not saying that your description here was bad…but just like a picture is worth 10000 words, so is some data. :-D

          1 Reply Last reply Reply Quote 0
          • First post
            Last post
          Copyright © 2014 NodeBB Forums | Contributors