Find & Replace w/multiple instances? (using a conversion file)
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?