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: 1974
Type: Advanced search and replace   
Search all Advanced search and replace examples
Description:
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
Answer:
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/288.rst.zip

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?
(61%)
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
Keywords:
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