Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

817.Text data calculation -- How to search and sum the numbers at specified position in a text file?

User: editor -- 2011-07-07          << 816  818 >>
Hits: 1742
Type: Text data calculation   
Search all Text data calculation examples
Description:
How to search and sum the numbers at specified position in a text file?
Input Sample:
...................
... ... 33 tools.
... 11 tools. ...... 55 tools.
......... 56 users.
.... ...
Output Sample:
33  tools
11  tools
55  tools

Total: 99 tools
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' dialog
* set 'search for pattern' to:

* set 'replace with pattern' to:

* uncheck 'print unmatched unit' option
* click 'advanced' tab:
* set 'run following for each match unit' to:

* set 'insert end text' to:

3. click 'replace', done.

Screenshot 1:  Replace_Window


Screenshot 2:  Replace_Advanced_Window


Similar Examples:
How to extract numbers in specified position and join with comma? (72%)
How to change the number in each line to specified order in a text file? (68%)
How to make search and replace only in specified lines in text file? (67%)
How to extract all lines with specified date range from text file? (67%)
How to batch extract specified lines from a text file? (67%)
How to find numbers in specified location and sort them? (65%)
How to count the number of specified part in each line? (65%)
How to search and replace words in specified column in csv file? (65%)

Check Demo of Text data calculation
Keywords:
position  total  var  insert end text  insert end  calculation  calcu  calculat  unmatched  unmatch  replace position  insert numbers  insert data  insert tab  insert text end text  insert text end  calculation in text file  and replace numbers in text file