#1 : 23/07-13 18:29 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 |
#2 : 21/09-13 07:33 arwul
Posts: 94
|
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. = |