Replace Pioneer Home   All Examples   Free Download

 New request --free  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: 1382
Type: Text data calculation   
Search all Text data calculation examples
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
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:

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
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