User: editor -- 2011-02-28 << 727 729 >> |
Hits: 2504 |
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 |