I have an attributetable. Spread all over it are numbers like -99999997. I want to replace them by zero (0). There a many columns in which there are such numbers. I have used the expression (an example with one column P-Ant_ARU)
case when "P_ANT_ARU" is -99999997 then '0' else "P_ANT_ARU" end
for every feature in the column but I wonder if there is a faster way to use in the field calculator to get rid of all the -99999997 in one or perhaps two steps, because there are a lot of columns :-)
I have also tried toint(0) but that doesn't work because you have to choose a field, and I want a value to be changed. The same problem occurs with the plugin QuickMultiAttributeEdit.
So how can I select all those numbers in the whole table and make them zero.