| User: editor -- 2011-02-28 << 727 729 >> |
| Hits: 330 |
| 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 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 calculate the summary of all numbers in multiple files? (60%)
How to calculate md5 hex value of each line of text file? (57%)
How to count the frequency of numbers base on the value range? (56%)
How to split a CSV file with Header according to value of a column? (55%)
How to duplicate column A by the number of times in column B in csv file? (55%)
|
|
Check Demo of Text data calculation |
| Keywords: |
| calculate tag calculation calcu csv 100 spli split data print replace with data data replace unit number with number file number file replace to replace 1 1 |