Can't replace attribute with field calculator

Question

I have an attribute table where one of the columns (laeskaerm) has been edited/created by checkboxes on 2 different machines.

Result: it contains both 1, 0, true, false and NULL

I'd like to replace 1 with true, and 0 with false. I've tried:

replace("laeskaerm",'1','true') 

and

replace("laeskaerm",'1','true')

But I can't seem to make it work (QGIS 2.2.0).

Do anyone have any idea whats wrong?

Answer 1

You could use the following expression to update your "laeskaerm" field:

CASE WHEN "laeskaerm" = 1 THEN 'True' 
WHEN "laeskaerm" = 2 THEN 'False'
ELSE "laeskaerm"
END

Answer 2

I found a solution

Instead of editing the fields myself I found a plugin that coould do the job (quickmultiattributeedit)

Thank you for your help and time

Answer 3

Try this

if("laeskaerm"='1' OR "laeskaerm"='true','true','false')

in 2.2

Case when "laeskaerm"='1' OR "laeskaerm"='true' then 'true'
Else 'false'
End