| User: editor -- 2011-07-12 << 818 820 >> |
| Hits: 3129 |
| Type: Text data calculation |
| Search all Text data calculation examples |
| Description: |
| How to calculate the average of all numbers that preceded by dollar sign? |
| Input Sample: |
| _____#33________$96.5_________ ______82____#28.6______ ________$92.8______$15______ _________________$100_______ |
| Output Sample: |
| $96.5 $92.8 $15 $100 Average: $76.08 |
| Answer: |
| Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps. |
| 1. ctrl-o open source text file 2. ctrl-h open 'replace' dialogue * set 'search for pattern' to: * set 'replace with pattern' to: * uncheck 'print unmatched unit' option 3. click "advanced" tab * set "run following for each matched unit" to: * set "insert end text" to: 4. click "replace", done! |
Screenshot 1: Replace_Window |
Screenshot 2: Replace_Advanced_Window |