File Renamer Basic
A newer version of File Renamer Basic is available.Or, Learn More About File Renamer Basic
Full user review
Handles regexp in plain English plus pure regexp. Handles Pascal scripts and more.
Other than only providing for scripts written in Pascal, there are no cons that I've found.
If you have to resort to writing a script to rename files you probably already have the ability to write scripts in Pascal or can adapt from another scripting language you do know. Worth every penny.