Reverse folder date

Post any Bulk Rename Utility support requirements here. Open to all registered users.

Reverse folder date

Postby bknghali » Thu Jun 06, 2013 9:16 pm

Hello,

Though Sony makes excellent DSLRs, unfortunately their mediocre software saves folders using only one date format option: MM_DD_YYYY i.e starting with the month!!!

Since this creates a whole mess in sorting the folders, I am wondering if I can setup BRU to read the current folder name and reverse it i.e change it to YYYY_MM_DD...
bknghali
 
Posts: 1
Joined: Thu Jun 06, 2013 8:55 pm

Reverse reorder rearrange date MM DD YYYY to YYYY MM DD

Postby Stefan » Fri Jun 07, 2013 12:34 pm

bknghali wrote:...software saves folders using date format : MM_DD_YYYY
HOW CAN I reverse it to YYYY_MM_DD


FROM:
MM_DD_YYYY
TO:
YYYY_MM_DD

Try regular expressions:
Match and store for later reuse as group 1 the Month==> (\d\d), accessible by '\1'
Then match and store in group 2 the Day==> (\d\d), accessible by '\2'
Then match and store in group 3 the year ==> (\d\d\d\d), accessible by '\3'

Match: (Month)_(Day)_(Year)
Match: (\d\d)_(\d\d)_(\d\d\d\d)


Now you can use what is stored in this groups to reorder the output as NewName.
Repla: Group3_Group1_Group2
Repla: \3_\1_\2


So use
RegEx(1)
Match: (\d\d)_(\d\d)_(\d\d\d\d)
Repla: \3_\1_\2




-

Reverse reorder rearrange date MM DD YYYY to YYYY MM DD
Stefan
 
Posts: 736
Joined: Fri Mar 11, 2005 7:46 pm
Location: Germany, EU


Return to BRU Support