Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1347.Count and statistics -- How to count the consecutive lines with the same pattern?

User: Verotiana -- 2016-02-22          << 1346  1348 >>
Hits: 858
Type: Count and statistics   
Search all Count and statistics examples
Description:
How to count the consecutive lines with the same sequence number (2nd column)
and same 3rd column. Output the 2nd and 3rd column and the result.
Input Sample:
15:40.728,90, E, R, R, , , , , , , , , , , , 
15:42.730,91, E, R, R, , , , , , , , , , , , 
16:00.734,100, E, R, D, , , , , , , , , , , , 
16:00.741,100, E, R, D, R, , , , , , , , , , ,
15:43.089,99, F, R, E, , , , , , , , , , , , 
15:43.109,99, F, R, E, , , , , , , , , , , , 
15:43.163,99, F, R, E, R, , , , , , , , , , , 
15:45.086,100, F, R, E, , , , , , , , , , , , 
15:45.131,100, F, R, E, R, , , , , , , , , , , 
15:47.089,101, F, R, E, , , , , , , , , , , , 
15:47.118,101, F, R, E, D, , , ,
Output Sample:
90 E 1
91 E 1
100 E 2
99 F 3
100 F 2
101 F 2
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 'settings' page:
* set 'para start' to other:

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

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Settings_Window


Similar Examples:
How to count the number of consecutive lines with specified pattern? (81%)
How to count the number of lines under each specified pattern? (66%)
How to merge consecutive lines that have the same first column? (64%)
How to count the number of consecutive identical lines? (62%)
How to eliminate consecutive return and spaces? (62%)
How to remove consecutive duplicate words in multiple files? (57%)
How to remove/delete consecutive duplicate lines in a text file? (57%)
How to count how many lines starting with an "a" ? (55%)

Check Demo of Count and statistics
Keywords:
3rd  consecutive  onsecutive  previous  2nd  cut  sequence number  non  paragraph  paragra  count consecutive lines  consecutive words  sequence number text file  replace text sequence number  replace text to sequence number  count start  same column  replace text number count