Photo Mechanic has a powerful find and replace feature that you can use to rename files and metadata fields. Navigate to Edit>Find and Replace... and fill out the dialog box.
You can use variables, and you can save your settings as a snapshot. Because the Replace feature replaces all instances, it's important to be as selective as possible with the fields you choose to replace.