### Replace Pioneer Home   All Examples   Free Download  RSS: Replace Pioneer Examples

# 1213.Text data calculation -- How to calculate the average of numbers of one column?

 User: Verotiana -- 2014-07-04          << 1212  1214 >> Hits: 1732 Type: Text data calculation Search all Text data calculation examples Description: How to calculate the average of numbers of one column Input Sample: Node 1 Average delay(s) = 0,0023 Node 2 Average delay(s) = 0,0124 Node 3 Average delay(s) = 0,0089 Node 4 Average delay(s) = 0,0546 Output Sample: 0,01955 Answer: Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. 1. ctrl-o open text file 2. ctrl-h open 'replace' dialogue * set 'replace unit' to 'Line' click 'advanced' tab: * set 'run following for each matched unit' to: \$N++; \$A+=words(\$match,2,2,'[=,]'); \$B+=words(\$match,3,3,'[=,]') * set 'insert end text' to: calc(\$A/\$N),calc(\$B/\$N)  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? (92%)How to calculate the percentage of the number in the column1? (85%)How to calculate the sum of the numbers in the same column? (80%)How to calculate the average of all numbers that preceded by dollar sign? (72%)How to calculate the absolute average value of every 2 columns? (69%)How to count the number of non-empty columns? (68%)How to calculate the summary of all numbers in multiple files? (65%)How to calculate sum value of every column? (64%) Check Demo of Text data calculation Keywords: average  rage  insert end text  insert end  calculate  calculation  calcu  calculat  insert  data  calculate average  insert column  insert numbers  insert words  insert data  insert end of file  calculate text data  insert tab