| User: editor -- 2008-06-22 << 196 198 >> |
| Hits: 3211 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| How to convert all date strings from format 2008-06-22 to format of 20080622 in a free format text files? |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source text file 2. ctrl-h open 'Replace' dialog * set 'Search for pattern' to: * set 'Replace with pattern' to: 3. click 'Replace', done! Notes: 1. \d\d\d\d-\d\d-\d\d matches date like 2008-06-02, formattime($match,"%Y%m%d") convert it to the format of YYYYmmdd 2. You can also add number of seconds on the original date like formattime($match,"%Y%m%d", 30*86400) means add original date by 30 days. 3. There are many other output format you can select, please search 'formattime' at online help documentation or page http://www.mind-pioneer.com/replace/help/Functions.html |
| Download Script: scripts/197.rst.zip |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to convert date from format 2011-01-12 to Jan-12-2011 in text file? (61%) How to batch rename files from format like TEST_2008_06_22_ABC.TXT to 20080622.TXT? (52%) How to convert the text from hex format to ascii format? (51%) How to generate 100 random date between 2009-01-01 and 2009-12-31? (51%) How to change all negative numbers to the format of (number)? (50%) How to generate consequence date from 2008-01-01 to 2009-12-31? (50%) How to convert the daily data into a weekly data with program? (50%) How to sort all the lines by the order of date with format day-month-year? (49%) |
Check Demo of Advanced search and replace |
| Keywords: |
| ddd free format text file free 640 odd seconds online matches yyyy functions free text free replace text number matches search all date format in files search and replace online files select all replace text online replace text online search and replace text online |