Advanced replace

[Américo J. C. Sousa]

Hello

I need help finding and replacing values ​​in a given situation

I have a .xml file and I need to find all the numbers inside this " <ClosingStockQuantity>0.5</ClosingStockQuantity> " and add + 0 to keep all values ​​that have one decimal place with two decimal places.

Thank you

[guy038]

Hello, @américo-j-c-sousa, and All,

Easy with regular expressions !

---

• Open your file in N++

• Open the Replace dialog ( Ctrl + H )

• Untick all box options

• FIND <(ClosingStockQuantity)>(\d+\.\d)</ClosingStockQuantity>

• REPLACE <$1>${2}0</$1>

• Check the Wrap around option

• Select the Regular expression search mode

• Click, once only, on the Replace All button or several times on the Replace button

Voila !

---

Thus, for this kind of INPUT text :

<ClosingStockQuantity>0.5</ClosingStockQuantity>
<ClosingStockQuantity>0.33</ClosingStockQuantity>
<ClosingStockQuantity>0.1</ClosingStockQuantity>
<ClosingStockQuantity>1</ClosingStockQuantity>
<ClosingStockQuantity>4.7</ClosingStockQuantity>
<ClosingStockQuantity>97.2</ClosingStockQuantity>
<ClosingStockQuantity>123</ClosingStockQuantity>

You should get your expected OUTPUT, below :

<ClosingStockQuantity>0.50</ClosingStockQuantity>
<ClosingStockQuantity>0.33</ClosingStockQuantity>
<ClosingStockQuantity>0.10</ClosingStockQuantity>
<ClosingStockQuantity>1</ClosingStockQuantity>
<ClosingStockQuantity>4.70</ClosingStockQuantity>
<ClosingStockQuantity>97.20</ClosingStockQuantity>
<ClosingStockQuantity>123</ClosingStockQuantity>

Best Regards,

guy038

[Mark Olson]

@Américo-J-C-Sousa
Try using the find-replace form (Search->Replace from the main menu or Ctrl+H with default keybindings) and do the following:

• Set Search Mode to Regular Expressions
• Check the Wrap around box
• Find what: <(ClosingStockQuantity>)(-?\d+)(\.\d)?</ClosingStockQuantity>
• Replace with: <${1}${2}(?3${3}0:.00)</${1}

This will add a zero as the second decimal place for all numbers that already have one decimal place, and a .00 after all numbers that don’t yet have any decimal places.

Note that this is just manipulating the numbers as text, not doing actual math. If you wanted to do math on the numbers, you will need to use a scripting language.