Replace Pioneer Home All Examples Free Download

289.Advanced search and replace -- How to multiply all money amount in a text file by 9?

User: editor -- 2008-11-01 << 288 290 >>

Hits: 3260

Type: Advanced search and replace

Search all Advanced search and replace examples

Description:

How to multiply all money amount in a text file by 9?

Input Sample:

item1 $2323.03
item2 $336.04 item3 $23.00

Output Sample:

item1 $20907.27
item2 $3024.36 item3 $207.00

Answer:

Hint: You need to Download and install "Replace Pioneer" on windows platform to finish following steps.

1. ctrl-o open source file
2. ctrl-h open 'Replace' dialog
in 'Replace' page
* set 'Search for pattern':

* set 'Replace with pattern':

3. click 'Replace', ok!

Note:  [\d\.]+ means any numbers.
calc(\1*9,'.2f') means multiply the number by 9

Download Script: scripts/289.rst.zip

Screenshot 1: Replace_Window

Similar Examples:

How to multiply every number by 1000 in a text file? (66%)
How to multiply the fifth column by 10 in a text file? (64%)
How to format all the data in the text file with 8.2 format? (63%)
How to shuffle all the lines in a text file? (63%)
How to extract all telephone numbers from a text file? (60%)
How to remove/delete all symbols in a text file? (60%)
How to extract all html address from a text file? (59%)
How to sort all the lines of a text file randomly? (59%)

Check Demo of Advanced search and replace

Keywords:

money multiply any number numbers calc means mean cal any replace page multiply all numbers text file multiply all numbers in file multiply all the numbers in a file multiply all numbers in a file multiply all numbers in a text file multiply all numbers in text file search and replace numbers multiply multiply numbers