| User: Verotiana -- 2013-07-10 << 1099 1101 >> |
| Hits: 3862 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to calculate the sum of the numbers in the same column? |
| Input Sample: |
| 1, , [0], MAC, 802.11s,CTP_Tx_Data = 0 2, , [0], MAC, 802.11s,CTP_Tx_Data = 560 3, , [0], MAC, 802.11s,CTP_Tx_Data = 560 4, , [0], MAC, 802.11s,CTP_Tx_Data = 0 5, , [0], MAC, 802.11s,CTP_Tx_Data = 0 6, , [0], MAC, 802.11s,CTP_Tx_Data = 560 7, , [0], MAC, 802.11s,CTP_Tx_Data = 560 |
| Output Sample: |
| 0+560+560+0+0+560+560 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| The solution is to calculate the sum of all numbers that followed "=". 1. ctrl-o open text file 2. ctrl-h open 'replace' dialogue * set 'search for pattern' to: * uncheck 'Print unmatched unit' option * click 'advanced' tab, set 'run following for each matched unit' to: * set 'insert end text' to: 3. click 'replace', done. |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |