Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

680.Text data calculation -- How to calculate summary of every column in a text file?

User: Lynne -- 2010-12-19          << 679  681 >>
Hits: 2051
Type: Text data calculation   
Search all Text data calculation examples
Description:
How to calculate sum value of every column?
Input Sample:
Line1 45.97
Line2 45.00
Line3 41.00
Line4 40.34
Line5 36.27
Line6 60.09
  .
  .
  .
Output Sample:
Line1 45.97
Line2 45.00+45.97
Line3 41.00+45.00+45.97
Line4 40.34+41.00+45.00+45.97
Line5 36.27+40.34+41.00+45.00+45.97
Line6 60.09+36.27+40.34+41.00+45.00+45.97
  .
  .
  .

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 source 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 match unit' to:

3. click 'Replace', done!

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to calculate the summaries of every line in a txt file? (87%)
How to calculate sum value of every column? (76%)
How to calculate sum of every column and keep original columns? (71%)
How to calculate the summary of all numbers in multiple files? (69%)
How to delete duplicate numbers in every line in text file? (67%)
How to add a column which is the summary of column 3,4 and 6 in text file? (65%)
How to multiply every number by 1000 in a text file? (64%)
How to calculate the absolute average value of every 2 columns? (63%)

Check Demo of Text data calculation
Keywords:
summary  calculate sum  max  calculate  calculation  calcu  calculat  every  data  very  calculate text summary  calculate sum in text file  calculate text data  sum column  value column  calculation in text file  replace with data  replace every