Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

197.Advanced search and replace -- How to convert all date from format 2008-06-22 to format of 20080622?

User: editor -- 2008-06-22          << 196  198 >>
Hits: 3556
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