| User: editor -- 2010-02-17 << 422 424 >> |
| Hits: 365 |
| Type: Advanced search and replace |
| Search all Advanced search and replace examples |
| Description: |
| I have a log file with the timestamp in each line, but the timestamp format is the number of seconds passed since 1970, how to convert it to the format of YYYY-mm-dd HH:MM:SS? |
| Input Sample: |
| 1034323423 start logging ... 1034334234 make operation 1034542343 end logging ... |
| Output Sample: |
| 2002-10-11 16:03:43 start logging ... 2002-10-11 19:03:54 make operation 2002-10-14 04:52:23 end logging ... |
| 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 'Replace Unit' to 'Chars' * set 'Replace Scope' to 'Line' * in search for pattern, enter: * in replace with pattern, enter: 3. Click 'Replace', done! |
| Download Script: scripts/423.rst.zip |
Screenshot 1: Replace_Window |
Similar Examples: |
| How to convert each line of a text file to the new format? (59%) How to convert a text file to specified format? (58%) How to convert the text from hex format to ascii format? (52%) How to convert file among MS word, PDF and TXT format? (52%) How to convert all the phrases to the Abbr automatically? (51%) How to convert many text files from encoding utf8 to utf8-BOM? (50%) How to convert the decimal IP address into binary format with 0 and 1? (50%) How to merge the data of second column base on value of first column? (50%) |
Check Demo of Advanced search and replace |
| Keywords: |
| seconds passed since timestamp pass convert date second date from time date scope convert date convert convert date to search convert number convert text to number convert to number search and replace date format in file number format replace date format |