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: 410
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  max  calculate  calculation  calcu  every  very  sum  join  tab  calculate sum in text file  sum column  calculate text data  value column  calculation in text file  replace every  replace with data  data replace