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: 1919
Type: Text data calculation   
Search all Text data calculation examples
Description:
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.
Answer:
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
Keywords:
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