| User: Adi Priyanto -- 2011-04-02 << 756 758 >> |
| Hits: 3237 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| 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 |
| Answer: |
| 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. Notes: 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 |
| Keywords: |
| 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 |