Peters Flexible RenAmiNg Kit (PFrank) Forum Index Peters Flexible RenAmiNg Kit (PFrank)
Support and Discussion Site for the PFrank File/Folder Renaming Tool (http://www3.telus.net/pfrank)
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Changing Date format and position

 
Post new topic   Reply to topic    Peters Flexible RenAmiNg Kit (PFrank) Forum Index -> Regular Expressions
View previous topic :: View next topic  
Author Message
RickPhil



Joined: 23 Apr 2011
Posts: 7

PostPosted: Sat Nov 09, 2013 3:49 pm    Post subject: Changing Date format and position Reply with quote

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.
Back to top
View user's profile Send private message
admin
Site Admin


Joined: 09 Mar 2007
Posts: 446
Location: Canada

PostPosted: Mon Nov 11, 2013 10:35 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
RickPhil



Joined: 23 Apr 2011
Posts: 7

PostPosted: Tue Nov 12, 2013 12:31 pm    Post subject: Changing Date format and position Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    Peters Flexible RenAmiNg Kit (PFrank) Forum Index -> Regular Expressions All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © phpBB Group. Hosted by phpBB.BizHat.com


Start Your Own Video Sharing Site

Free Web Hosting | Free Forum Hosting | FlashWebHost.com | Image Hosting | Photo Gallery | FreeMarriage.com

Powered by PhpBBweb.com, setup your forum now!
For Support, visit Forums.BizHat.com