Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

819.Text data calculation -- How to calculate the average of all numbers that preceded by dollar sign?

User: editor -- 2011-07-12          << 818  820 >>
Hits: 1777
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


Similar Examples:
How to calculate the average of numbers of one column? (72%)
How to calculate the average of the numbers in the same column? (70%)
How to calculate the percentage of the number in the column1? (63%)
How to calculate the summary of all numbers in multiple files? (61%)
How to calculate the sum of the numbers in the same column? (59%)
How to extract all english words that preceded by multi-byte characters? (54%)
How to delete from FILE A all lines that appear in file B? (54%)
How to multiply by 1.5 for all numbers with xr suffix? (53%)

Check Demo of Text data calculation
Keywords:
dollar  average of all numbers  sig  average  rage  var  insert end text  insert end  calculate  calculation  calculate average  insert numbers  insert data  search calculate replace  search replace calculate  calculate text data  insert tab  insert text end text