add text value to attributes

Question

this is a novice question

I have an attribute field that's missing a piece of information, i'd like to amend the attribute field like below:

This is the current attribute field:

"V:\Building & Development...."

and i'd like to add "\Engineering" to attribute field

"V:\Engineering\Building & Development...."

I have to make this change to 1441 attribute fields, not sure how to write the python script in the field calculator. I'm doing this on ArcGIS 10.2 for Desktop

Answer 1

Using the Python parser in the field calculator:

Pre-logic script code:

def convert(x):
  a = x.split(":")
  return a[0] + ":\Engineering" + a[1]

---

convert(!text_field!)

---

You can also use an UpdateCursor to do this

import arcpy

fc = r'path\to\your\fc'

with arcpy.da.UpdateCursor(fc, "your_field") as cursor:
    for row in cursor:
        if row[0] != None:
            a = row[0].split(":")
            row[0] = a[0] + ":\Engineering" + a[1]
            cursor.updateRow(row)

---