Conditional replace function in Field Calculator

BenjaminYoung

I'm trying to write an expression that will allow me to change the text of a string field based on it's values.

Here's what I have so far.

----

Dim output as String

IF [DUPLICATE] = "0"
THEN
output = replace( [DUPLICATE], "0", "CATEGORY 1")
end if

IF [DUPLICATE] = "1"
THEN
output = replace( [DUPLICATE], "1", "CATEGORY 2")
end if

IF [DUPLICATE] = "2"
THEN
output = replace( [DUPLICATE], "2", "CATEGORY 3")
end
----

Any help would be appreciated.

DarrenWiens2

Firstly, you need to decide if you want to use VBScript or Python. You started with almost functional VBScript and have been slowly drifting into functional Python.

PYTHON:
In the expression box:

func(!DUPLICATE!)

Then, in the codeblock:

def func(dup):
    if dup == "0":
        return "CATEGORY 1"
    elif dup == "1":
        return "CATEGORY 2"
 

VBSCRIPT:
In the expression box:

result

Codeblock:

if [DUPLICATE] = 0 then
  result = "CATEGORY 1"
elseif [DUPLICATE] = 1 then
  result = "CATEGORY 2"
else
  result = [DUPLICATE]
end if