Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

759.Text data calculation -- How to calculate sum value of every column?

User: Lynne -- 2011-04-07          << 758  760 >>
Hits: 1955
Type: Text data calculation   
Search all Text data calculation examples
How to calculate sum value of every column?
Input Sample:
Line1 AA-01 1
Line2 AA-02 1
Line3 AA-03 1
Line4 AA-04 1
Line5 AA-05 1
Line6 AA-06 1
Output Sample:
Line1 AA-01 1 1+0=1         1+0=
Line2 AA-02 1 1+1=2         1+2=
Line3 AA-03 1 1+1+1=3       1+2+3=
Line4 AA-04 1 1+1+1+1=4     1+2+3+4=
Line5 AA-05 1 1+1+1+1+1=5   1+2+3+4+5=
Line6 AA-06 1 1+1+1+1+1+1=6 1+2+3+4+5+6=

There are 200 lines and 200 columns in one text file.
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open the text file
2. ctrl-h open 'replace' window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

* click 'advanced' tab
* set 'run following for each matched unit' to:

3. click 'replace', done.
4. ctrl-s save to file.

Screenshot 1:  Replace_Window

Screenshot 2:  Replace_Advanced_Window

Similar Examples:
How to calculate the absolute average value of every 2 columns? (79%)
How to calculate summary of every column in a text file? (76%)
How to calculate the sum of the numbers in the same column? (73%)
How to calculate the average of numbers of one column? (72%)
How to calculate the average of the numbers in the same column? (69%)
How to calculate the percentage of the number in the column1? (68%)
How to calculate the summaries of every line in a txt file? (68%)
How to calculate the total energy consumption in group? (67%)

Check Demo of Text data calculation
calculate sum  calculate  calculation  calcu  calculat  every  data  very  calc  sum  calculate text data  sum column  value column  replace with data  replace every  data replace  sum replace  replace column