I currently have files named like this:
i.e. There are multiple files with the same first 16 digit string (which is the main identifier).
I have a .txt file with new file numbers that correspond to those 16 digit strings:
When I tried to run the utility, I first removed the last 19 characters from the original file. I had to add numbering at the end to differentiate the new files, otherwise they would not save. After saving, the new files looked like this:
However, the key point now is that since my .txt file does not contain the new ending numerals, the import function cannot match up the files with their new names.
My ideal output is:
Any suggestions would be greatly appreciated. Ironically I believe I figured out how to do this using BRU a couple of years ago, but now I am at a loss!