Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1342.Text data calculation -- How to make a subtraction of the specified time string?

User: Verotiana -- 2016-02-16          << 1341  1343 >>
Hits: 642
Type: Text data calculation   
Search all Text data calculation examples
Description:
Make a subtraction of the first column (time value) of two lines with the same
value of the second column. Copy the 2nd, 3rd and 4th column followed by the
result.
Input Sample:
14:55:23.997214, 1469, G, R, F, , , , , , , , , , , , 
14:55:24.043214, 1469, G, R, F, C, B, R, , , , , , , , , 
14:55:24.806215, 1546, F, R, C, , , , , , , , , , , , 
14:55:24.844215, 1546, F, R, C, B, R, , , , , , , , , , 
14:55:24.868216, 976, E, R, C, , , , , , , , , , , , 
14:55:24.913216, 976, E, R, C, B, R, , , , , , , , , , 
Output Sample:
1469 G R 0.046
1546 F R 0.038
946 E R 0.045
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 'replace unit' to 'Paragraph'
* set 'replace with pattern' to:

* click 'advanced' tab, set 'run following at the beginning of replace' to:

* click 'settings' tab, set 'para start' to 'other':

* set 'para end' to 'None'
3. click 'replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Screenshot 3:  Replace_Settings_Window


Similar Examples:
How to extract text between specified start and end strings? (63%)
How to convert a duration of seconds to a time format? (60%)
How to extract all lines with specified date range from text file? (60%)
How to replace the specified text with increasing HEX strings? (60%)
How to add a space at the specific location of each line? (59%)
How to extract lines with specific words in first column? (58%)
How to extract numbers in specified position and join with comma? (57%)
How to replace the certain column with specified words? (57%)

Check Demo of Text data calculation
Keywords:
subtract  4th  3rd  two lines  previous  2nd  second column  return  non  two  first two words  string second time  return tab  two lines of text  same value  first two  the first two  first and second words