Code Help

JonPeroff

I'm in need of some help.  I have a file with a attribute field named SPCOMP and I need to separate it out.  The SPCOMP field is populated with a string such as "Sb  90Bf  10" or Pj  80Sb  20" or Pj  40Bw  40Sb  20"  etc.  I'm trying to write a code using the field calculator in VB

script that will search through the SPCOMP field for "Sb  90" and populate another field SB with 90 or search for "Sb  60" and put 60

in the SB field.  My code is:

Dim SB

if [SPCOMP] = "%Sb  90%" Then

SB = 90

elseif [SPCOMP] = "%Sb  60%" Then

SB = 60

else

SB = 1

end if

When I run this it will populate the SB field with 1 so I think my mistake is with the wildcard search?  Can anyone offer suggestions on this or where I could find answers?  I'm using ArcGIS advanced 10.3.

Thanks

XanderBakker

As mentioned before, I would probably use some Python code to do the job:

This table was updated using this code:

def main():
    import arcpy
    fc = r"C:\GeoNet\SPCOMP\ARC.gdb\SPCOMP"
    fld_in = "SPCOMP"

    # create list of fields with length 2
    flds = [fld.name for fld in arcpy.ListFields(fc) if len(fld.name) == 2]
    flds.insert(0, fld_in)

    # start update cursor
    with arcpy.da.UpdateCursor(fc, flds) as curs:
        for row in curs:
            spcomp = row[0].upper()
            for fldname in flds[1:]:
                if fldname.upper() in spcomp:
                    perc = getPercentage(fldname.upper(), spcomp)
                    row[flds.index(fldname)] = perc
            curs.updateRow(row)

def getPercentage(fldname, spcomp):
    try:
        n = spcomp.find(fldname)
        part = spcomp[n+2:n+6]
        return int(part)
    except:
        return -1

if __name__ == '__main__':
    main()

Some assumptions that seem to be true for this table:

• field names that need to be updated are two characters long and correspond to the specie
• a species inside the field SPCOMP always occupies 5 characters.