How do I handle complex bulk file renaming tasks in windows?
The most useful utility I've ever used for bulk file renaming is Bulk Rename Utility. You might not even know you need this tool until after you use it.
The utility is donation-ware, so if you use it a few times send them $10 to show your appreciation for the developers hard work.
In addition to a large array of built in filename manipulation tools such as "ignore the first # characters in the selected files", this Bulk Rename Utility can also use regular expressions to make renaming rules for a group of files.
Features: Instead of me listing what this utility can do, check out the features page:
Actually I do need to mention one of the best features which is new filenames are shown in a preview column ("New Name" column in the image below) and this by itself makes this utility worth using.
A picture is worth a thousand words: