Find records with number/character that should not be there.

Question

I have a filed that I need to find records in a layer that have a number that should not be there. Not really sure on how to do this.

Rec field has length of 10. In the example below the first and fourth records has 0 in the 9th space (it could be a different digit) and some records will have an alph character in the 9th space, which is ok as long as it's an alph character. I would like to somehow mark the records.  Essentially, I need to find which records have a digit(skip if alph character is there) on the 9th space of the records. Hopefully this makes sense.

Rec

mark

12345678 0ok ( or 1)22345108A0ok ( or 0)6523148000Not ok ( or 0)62315010 9Ok ( or 1)6218921801Not ok ( or 0)

CCWeedcontrol · Answer

I tried you function but I couldn't get it to work right.

pre-logic script code:

def mark_records(records):
    result = []
    for rec in records:
        # Check if the 9th character (index  is an alphabetic character
        if rec[8].isalpha() or rec[8].isspace():
            # Mark as ok
            result.append({"Rec": rec, "Mark": "ok"})
        elif rec[8].isdigit():
            # Mark as Not ok
            result.append({"Rec": rec, "Mark": "Not ok"})
        else:
            # If neither alphabetic nor digit nor space, mark as Invalid
            result.append({"Rec": rec, "Mark": "Invalid"})
    return result

Field = (!rec!)

CCWeedcontrol · Answer

oh I see, line 9  (row[0])[8].isnumeric.

Thanks for the help.

DavidPike · Answer

import arcpy

in_table = "fc"
field_names = ["rec", "mark?"]

with arcpy.da.UpdateCursor(in_table, field_names) as cursor:
    for row in cursor:
        try:
            if (row[0])[8].isnumeric():
                row[1] = 'Not OK'
            else :
                row[1] = 'OK'
        except:
            row[1] = 'Some error'
        cursor.updateRow(row)