I think a script may already exist for this, but I can't seem to find it. I'm working on a book with a couple of hundred images from stock agencies. When the photos are purchased, they come with an appended name.
and then the file is converted to the correct colour profile and becomes
In the past I've used Namemangler to rename photos and relink, but I'd rather maintain the file naming convention, should the links ever break a year or two down the road when files are migrated.