Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1100.Text data calculation -- How to calculate the sum of the numbers in the same column?

User: Verotiana -- 2013-07-10          << 1099  1101 >>
Hits: 1354
Type: Text data calculation   
Search all Text data calculation examples
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:
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

Similar Examples:
How to calculate the average of the numbers in the same column? (88%)
How to calculate the average of numbers of one column? (80%)
How to calculate the percentage of the number in the column1? (76%)
How to calculate sum value of every column? (73%)
How to calculate the summary of all numbers in multiple files? (73%)
How to replace a words with the previous word in the same column? (64%)
How to count the number of non-empty columns? (63%)
How to calculate summary of every column in a text file? (62%)

Check Demo of Text data calculation
same column  var  insert end text  insert end  calculate  calculation  calcu  calculat  same  all numbers  calculate sum  insert column  insert numbers  insert data  search calculate replace  search replace calculate  calculate text data  sum column