[GIS] Find and replace, field calculator

arcgis-10.1arcgis-desktopfield-calculatorpythonvbscript

Can someone show me a very simple find and replace in field calculator for just one or two characters in a field based hyperlink?

Best Answer

If I understand correctly, you might try something like the replace() function:

VBS

replace([FieldName], "Old Value", "New Value")

Python

!FieldName!.replace("Old Value", "New Value")

Here is a link to the ESRI support page for it: http://support.esri.com/en/knowledgebase/techarticles/detail/20119

Related Solutions

[GIS] Field Calculator expression to replace string only if it occurs

A couple things to note:

Your code block is currently taking two arguments, but you really only need to take one. AKA_STREET_TEST1 is the result you want, not something that Calc() will consider when calculating. So your expression should be Calc(!STREET1!) -- because you want the function Calc to do something using the information from field STREET1, and that value will then be assigned to AKA_STREET_TEST1.

You can use a simple, one-line operation with Python's string.replace function, which essentially incorporates your if-then logic automatically. If AVENUE is in the string, it will be replaced with AVE. If AVENUE isn't there, it returns nothing and should leave the attribute empty.

def Calc(value):
    if "AVENUE" in value:
        return value.replace('AVENUE','AVE')

VBScript If/Then Statement – How to Use If/Then Statement in VBScript for ArcGIS Field Calculator

Normally, I try to direct anyone using the Field Calculator to use Python. But to answer your question directly, you'll need something similar to this below. It's a basic pattern of if/elseif/end if.

(substitute your own values of course, I use 9999/Z just to show an elseif)

enter image description here

Note: You mention that MUSYM is a number, but the way the values in your table are aligned to the left makes me think it is stored as a text field. If so, try the below instead: