| User: Dilip -- 2014-09-06 << 1243 1245 >> |
| Hits: 3129 |
| 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 |