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 |