The basic regular expression are listed in this page. Understanding regular expression is not so easy, but it gives big flexibility. Regular expression may can meet your almost requirements for renaming.
The following example is removing numbering prefixes and path extensions. In the "Replace with" field, you can refer a part or whole of matched string by using $0, $1, ...