by Jack2 » Wed Dec 23, 2020 9:16 am
You could use this spreadsheet to make the text for an "Import Pairs" list that can be used in Bulk Rename Utility
http://s000.tinyupload.com/index.php?file_id=36294295953346357025
(if your files are in multiple folders, you've had to make a list for each folder).
---
in more detail:
0) Copy row 11 of the spreadsheet down the page for as many files/lines as you have
1) Get a list of your filenames (including the extensions) into a .TXT file using
a) windows command line (dir *.* /b /s /a:-D >Filelist.txt) (or similar, you might need to tweak the arguments);
b)or using apps like
https://www.karenware.com/powertools/karens-directory-printer
or
https://download.cnet.com/PrintFolders/3000-2248_4-10067127.html
.
2) Paste your list of filenames into Column A of the spreadsheet
3) column J will show the new filenames, as-per your format
4) column K will show the text needed by Bulk Rename Utility
copy-paste Column K into a new text document and save it somewhere as, say, NewPairs.txt .
5) go to BRU, use menu option Actions>Import Data Pairs, navigate to NewPairs.txt, and load it.
6) in BRU main UI window, navigate to the folder with your original files and Select all the files in the main window in BRU, and rename them in the usual way.