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

# 1105.Text data calculation -- How to make math calculation on columns and generate a new column of result?

 User: shan feng -- 2013-07-15          << 1104  1106 >> Hits: 1690 Type: Text data calculation Search all Text data calculation examples Description: How to calculate with formula? Assume the fifth colume is A,the sixth column is B,the formula is C=100-10*0.77*(A-B) ,let C replace B.If C<0,let C=0;if C>100,let C=100. Input Sample: 4 41 5 6 29.2 25.1 4 41 5 6 29.6 12.5 4 41 5 6 24.7 24.8 Output Sample: 4 41 5 6 29.2 68.43 4 41 5 6 29.6 0 4 41 5 6 24.7 100 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' * set 'replace with pattern' to: words(\$match,1,5,' ',' ') max(min(100-10*0.77*(\$match-\$match),100),0)\n 3. click 'replace', done. Screenshot 1:  Replace_Window Similar Examples: How to merge more columns into one column in multiple csv files? (53%)How to append the second columns of file A and B if first columns are identical? (53%)How to batch append the columns of file A and B if third  columns are identical? (53%)How to batch split files into columns that separated by comma? (53%)How to batch calculate numbers and make the result divisible by 5? (52%)How to change all lines to columns in a text? (51%)How to take cell A2,A4,A6,A8,... out from column A and put them in a new column B in excel? (51%)How to make expression calculation in a text file? (51%) Check Demo of Text data calculation Keywords: the sixth  fifth  sixth  math  max  calculate  calculation  calcu  calculat  columns  column math  generate column  calculate text data  text columns  text to columns  replace with data  data replace  replace column