I kind of made a mistake, with a certain setting one column to a value map. Originnaly the "Regio Column' had text which consited of four specific value's (five if I count Null with it). To make thing simplier for field work, I decided to add a dropdown list, and for specific "numbering reason" of the object I gave each text a number, but in actuality they see only the text they need to choose. But something went wrong and it is kind of my own fault since I needed to replaced text. I cannot change this now.

Now because I have over 3000 records changing manualy those (centrum) and other values to the actual value of the value map choice by choosing down the dropdown list is kind of tedious. I tried to use the replace function but I cannot get it right. To illustrate see image below:

enter image description here

What I am doing wrong here?

  • You are missing a comma. The expression is: replace("Omschrijving", '(centrum)','1')
    – Albert
    Mar 29, 2017 at 9:41

1 Answer 1


You missed a comma after your field, it should be

replace("Regio", '(centrum)', '1')
  • Ah thank you I wil test it out. If it works I will set this as accepted. Mar 29, 2017 at 9:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.