Find and replace subset of string

[Douglas McAlpine]

Hi there,

I have a large file in which I want to replace any strings in my file where Buchwert has a decimal place and replace it with 0

So this is ok
bestand=“-6718” buchwert=“0” wrtmndrng_kmlrt=“0”

But this is a problem
bestand=“6719” buchwert=“0.831392131958484” wrtmndrng_kmlrt=“0”

How do I do it without deleting anything past the second "?

[Douglas McAlpine]

In the end I got this working with:

Find what:
"buchwert=“0.[0-9]+” "

Replace:
buchwert=“0”

[gerdb42]

Search for Regular Expression: buchwert="0\.\d+"
Replace with: buchwert="0"

If you need to replace any number with decimals search for buchwert="\d+\.\d+"

[gerdb42]

Ok, I see you found it by yourself. Note that \d is equivalent to [0-9]. But you need to escape the "." to "\." or else it will match any character e.g. “0n234” would also match.