Peters Flexible RenAmiNg Kit (PFrank)

RickPhil · Joined: 23 Apr 2011 Posts: 7

How can I change the date format from '13.09.26.' to '13-09-13' while removing any other periods (.) in the file name and replacing them with whitespace? I'd also like to move the date new format to the end of the file name.

admin · Site Admin Joined: 09 Mar 2007 Posts: 448 Location: Canada

Hi,

Enter the following into the custom renaming creator (leave out the single quotes):

Row: 1
Search: '(?E)(.*)([0-9][0-9])\.([0-9][0-9])\.([0-9][0-9])(.*)'
Replace: '\1\2-\3-\4\5'
Row: 2
Search: '(?E)\.'
Replace: ' '
Row: 3
Search: '(?E)(.*)([0-9][0-9]\-[0-9][0-9]\-[0-9][0-9])(.*)'
Replace: '\1\3 \2'

Hope that helps.
Sorry for the late response.

Peter.

RickPhil · Joined: 23 Apr 2011 Posts: 7

Row 1 works perfectly.

I think row two works fine but I see instances where one of the periods isn't replaced with a space. I'll test it some more.

I have to play around with row 3 as some of the titles have more words and the search is looking for only three fields.

Thanks so much for the help. I may be coming back for more.

Rick