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

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