Replace Pioneer Home
All Examples
Free Download
all
Advanced search and replace
Replace text in multiple files
Regular expression replace
Batch file rename
Batch download
Text file parser
Text file splitter
Html text generator
Search replace binary
Random word generator
Count and statistics
Character encoding
Bin Hex Oct Dec converter
Text generator
Text sort
Text merge
Text data calculation
RSS: Replace Pioneer Examples
1291.Text data calculation -- How to convert a duration of seconds to a time format?
User:
Soly -- 2015-04-01
<< 1290
1292 >>
Hits:
2788
Type:
Text data calculation
Search all
Text data calculation
examples
Description:
How to convert a duration of seconds to a time format?
Input Sample:
8750
Output Sample:
02:25:50
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' dialogue
* set 'search for pattern' to:
\d+
* set 'replace with pattern' to:
sprintf("%02d:%02d:%02d",$match/3600,($match%3600)/60,$match%60)
or
formattime_gm('1970-01-01',"%H:%M:%S",$match)
3. click 'replace', done.
Screenshot 1: Replace_Window
Similar Examples:
How to convert date from seconds passed since 1970 to YMD format?
(68%)
How to convert a text file to specified format?
(66%)
How to convert a list of phone numbers to required format?
(64%)
How to convert the text from hex format to ascii format?
(64%)
How to convert each line of a text file to the new format?
(64%)
How to make a subtraction of the specified time string?
(60%)
How to change the direction of all sentences in a text file?
(60%)
How to convert the data into a table with columns?
(60%)
Check Demo of
Text data calculation
Keywords:
600
seconds
formattime
time format
calculation
calcu
calculat
second
how to convert
convert
convert a calculation to text
text 60 format
replace time format
format convert
convert text file search replace
search data
convert text
replace convert