Replace Pioneer Home   All Examples   Free Download

 New request --free  RSS: Replace Pioneer Examples

1244.Text data calculation -- How to batch calculate numbers and make the result divisible by 5?

User: Dilip -- 2014-09-06          << 1243  1245 >>
Hits: 1060
Type: Text data calculation   
Search all Text data calculation examples
Description:
I am having tab separated numerical values in a text file. I want to execute the
=CEILING(A1*1.22,5) and =CEILING(B1*1.22,5) function in found in Excel which will
first multiply the numerical value (both whole numbers and decimal numbers) and
then I want to make the end result divisible by 5
Input Sample:
303.28 242.62
303.28 272.95
319 255
303.28 242.62
319.67 255.74
344.26 275.41
Output Sample:
375 300
375 335
390 315
375 300
390 315
420 340
Answer:
Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.
1. ctrl-o open text file
2. ctrl-h open 'replace' dialogue
* set 'search for pattern' to:

* set 'replace with pattern' to:

3. click 'replace', done.

Screenshot 1:  Replace_Window


Similar Examples:
How to batch replace files and save the result to new files? (62%)
How to calculate the summary of all numbers in multiple files? (58%)
How to extract all telephone numbers from a text file? (56%)
How to calculate the sum of the numbers in the same column? (55%)
How to calculate the summaries of every line in a txt file? (55%)
How to calculate the minimum and maximum value in each line of text? (55%)
How to reset all the numbers with format id=NNN in a text file?  (55%)
How to extract all lines whose line numbers are multiple of 3? (54%)

Check Demo of Text data calculation
Keywords:
whole number  decimal numbers  avi  decimal number  multiply  div  excel  whole  decimal  cut  numbers with decimal in batch file  batch file decimal numbers  batch multiply  search and replace numbers multiply  multiply numbers  multiply numbers in text file  search numbers in file and multiply  multiply in text file