Replace Pioneer Home All Examples Free Download

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

User: Verotiana -- 2016-02-16 << 1341 1343 >>

Hits: 2593

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 move strings matching specified patterns? (62%)
How to extract specified text from pdf files? (60%)
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%)

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