Replace Pioneer Home All Examples Free Download

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

User: Lynne -- 2011-04-07 << 758 760 >>

Hits: 3124

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 one column base on value of another column? (74%)
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%)

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