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: 285
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 change the number in each line to specified order in a text file? (68%)
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 search and replace words in specified column in csv file? (65%)
How to add some number to the specific column in csv file? (65%)
How to insert a line after specific lines in a text file? (64%)
How to extract multiple lines in specified order from many text files? (63%)
How to change columns in each line to specified order in text file? (63%)

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