Rename photos/video using part of the original file name

Hi

This seems to be an excellent tool!
But as a newbie I need some help.
I have looked in the help and the most recent posts in the forum, but without any luck!

Case:
Original filename1:
IMG_1234.jpg
Original filename2:
AVI_5678.mov
Original filename3:
PC019012.JPG

Desired filename1:
2012-12-31 (1234) - Activity.jpg
Desired filename2:
2012-12-31 (5678) - Activity.mov
Desired filename2:
2012-12-31 (9012) - Activity.JPG

I would think that in pseudo code, it could look something like this:
Original1 & 2:
<crap>_<number>.<Ext>
Original3:
<crap>01<number>.<Ext>
->
New:
2012-12-31 (<number>) - Activity.<Ext>

For original 1 and 2 I think I could use something like this:
2012-12-31 (<Word:2>) - Activity.<Ext> (if I make sure that underscore is one of the separation characters).
But how can I make it work on original 3? (chosing "1" as a separation character is not a good idea, I think!).

I hope someone can help.

Best regards.
Ivan

---

Reply to #1:
If the number you want to reuse is always the last 4 characters you can use the RSubStr tag to extract those last 4 characters. You can use the New Name method and use this new name pattern:
2012-12-31 (<rsubstr:1:4>) - Activity

Remember to set Apply To to Name. That way you don't need to handle the extension.

I hope this helps you in the right direction.

---

Reply to #2:
Brilliant. Thanks a lot!

---