Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

757.Advanced search and replace -- How to convert date format from "March 9, 2009 at 4:26pm" to defined format?

User: Adi Priyanto -- 2011-04-02          << 756  758 >>
Hits: 1705
Type: Advanced search and replace   
Search all Advanced search and replace examples
How to change date format from "March 9, 2009 at 4:26pm" to "2009-03-09 16:26"?
Input Sample:
March 9, 2009 at 4:26pm
Output Sample:
2009-03-09 16:26
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file
2. ctrl-h open replace window
* set 'search for pattern' to:

* set 'replace with pattern' to:

3. click 'replace', done.
4. ctrl-s save to file.

Explanation to above steps:
Firstly, search the date string and convert to the format of "09-Mar-2009 4:26", which is supported by system.
Secondly, add 12 hours if "pm" exists
Thirdly, convert the date to format of "2009-03-09 16:26".

Screenshot 1:  Replace_Window

Similar Examples:
How to convert the text from hex format to ascii format? (61%)
How to convert pipe separated elements in each line to specified format? (60%)
How to decorate each of marching number with specified format? (58%)
How to convert date from format 2011-01-12 to Jan-12-2011 in text file? (58%)
How to convert a text file to specified format? (57%)
How to convert multiple text files to html files with self-defined format? (56%)
How to convert the text format by user specified rules? (56%)
How to change the numbering format in a text file to a new format? (52%)

Check Demo of Advanced search and replace
ddd  600  third  convert date  change date format  123  formattime  200  system  support  convert date text  convert date to search  replace convert date  date convert  add string with replace  add string  add 1 to string  replace date format