3

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 '17 at 9:41
2

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. – ThunderSpark Mar 29 '17 at 9:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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