| User: Lynne -- 2010-12-19 << 679 681 >> |
| Hits: 3630 |
| 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 |