Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

728.Text data calculation -- How to calculate the percentage of the number in the column1?

User: editor -- 2011-02-28          << 727  729 >>
Hits: 1893
Type: Text data calculation   
Search all Text data calculation examples
Description:
How to calculate the percentage of the number in the column1?
Input Sample:
38,27,96
39,55,39
42,66,18
Output Sample:
38,27,96,23.60%
39,55,39,29.32%
42,66,18,33.33%
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open source text/csv file
2. ctrl-h open 'replace' window
* set 'replace unit' to 'Line'
* set 'replace with pattern' to:

3. click 'replace', done.
4. ctrl-s save to file.

Screenshot 1:  Replace_Window


Similar Examples:
How to calculate the average of numbers of one column? (85%)
How to calculate the average of the numbers in the same column? (84%)
How to calculate the sum of the numbers in the same column? (76%)
How to calculate sum value of every column? (68%)
How to calculate the absolute average value of every 2 columns? (67%)
How to calculate the average of all numbers that preceded by dollar sign? (63%)
How to count the number of non-empty columns? (62%)
How to calculate the summary of all numbers in multiple files? (60%)

Check Demo of Text data calculation
Keywords:
110  calculate  tag  calculation  calcu  calculat  100  csv  data  calc  replace with data  data replace  unit number  pattern number  with number  replace number  file number  replace pattern