Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

288.Advanced search and replace -- How to summrize the number of second column grouping by the first column?

User: editor -- 2008-10-30          << 287  289 >>
Hits: 2488
Type: Advanced search and replace   
Search all Advanced search and replace examples
How to summrize the number of second column grouping by the first column?
Input Sample:
item1 200 
item2 120 
item1 250 
item3 99 
item2 18
Output Sample:
item1 450 
item2 138 
item3 99
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 Line. 
click "Advanced" page: 
* set "run following at the beginning of replace" to: 
* set "run following for each matched unit" to: 
* set "insert end text" to: 
Download Script:  scripts/

Screenshot 1:  Replace_Window

Screenshot 2:  Replace_Advanced_Window

Similar Examples:
How to merge the data of second column base on value of first column? (69%)
How to merge remaining columns into the first column? (64%)
How to merge other columns one by one into the first column? (63%)
How to find all elements appearing in second column and not appearing in first column?
How to add some number to the specific column in csv file? (60%)
How to merge other columns' data base on the value of the first column? (58%)
How to append the second columns of file A and B if first columns are identical? (56%)
How to divide each column by the first number? (55%)

Check Demo of Advanced search and replace
summrize  toc  second column  group  insert end text  insert end  first column  values  second  clear  insert column  insert beginning  insert text at beginning  beginning end  search by column  insert text end text  insert text end  replace number column