Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

463.Advanced search and replace -- How to change date format from Aug-12-2008 to format like 2008-08-12?

User: editor -- 2010-03-31          << 462  464 >>
Hits: 3270
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
How to change date format from Aug-12-2008 to format like 2008-08-12? 
Input Sample:
date1 Mar-25-2010  
date2 Feb-28-2010  
date3 Aug-12-2008
Output Sample:
date1 2010-03-25  
date2 2010-02-28  
date3 2008-08-12
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text file that containing the date 
2. ctrl-h open replace window 
* in 'search for pattern', enter: 
 
* in 'replace with pattern', enter: 
 
3. click 'Replace', done! 
 
Note Mar-12-2010 is not system recogonized data format, so here we convert it into 12/Mar/2010("$2/$1/$3") first
Download Script:  scripts/463.rst.zip

Screenshot 1:  Replace_Window


Similar Examples:
How to change date format from 2010-03-25 to format like Mar-25-2010? (74%)
How to change the format of url and add ".htm" at end? (52%)
How to change the numbering format in a text file to a new format? (51%)
How to convert date format from "March 9, 2009 at 4:26pm" to defined format? (51%)
How to change text file format with user specified rules? (51%)
How to convert the text from hex format to ascii format? (50%)
How to batch change format of multiple files? (48%)
How to extract all specified date format from a text file? (47%)

Check Demo of Advanced search and replace
Keywords:
ddd  change date format  formattime  200  system  date format  change date  containing  date  convert  convert date text  convert date to search  replace convert date  convert date  date convert  search and replace date format in  replace date format  format date