Take Date from Filename

Advanced Renamer forum
#1 : 23/07-13 18:29
Axel
Axel
Posts: 1
Hello,

I receive doc with a name xxxxxxx_20130718.

For better sorting in Explorer I want to identify the date at the end of the name and move it in front of the name.

Result should be:

2013-07-18 xxxxxxx

Is this possible ? The length of the name is different, I can't say "start on pos 18".

Thx for any tips

CU,
Axel


23/07-13 18:29
#2 : 21/09-13 07:33
arwul
arwul
Posts: 88
Reply to #1:
Hi, maybe this problem has already been solved.
I think the best way is to solve it using regular expressions.

Source files (examples):
Lorem Ipsum_20111006.html
Lorem Ipsum_20060125.html
Lorem Ipsum_19950525.xls
Lorem Ipsum_19780226.xls

Find: (.+)_(\d{4})(\d{2})(\d{2})\.(.+)
Replace: $2-$3-$4 $1.$5

Results into:
2011-10-06 Lorem Ipsum.html
2006-01-25 Lorem Ipsum.html
1995-05-25 Lorem Ipsum.xls
1978-02-26 Lorem Ipsum.xls

Maybe this will work for you?

Good luck.
=


21/09-13 07:33