Arcpy - Stripping out strings in a field seperated by comma (with nulls)

timdunlevie1

Hi all,

I have a feature class which has 1 field which are hyperlinks to photos:

e.g. [PHOTO] : C:\temp\photo1.jpg, c:\temp\photo2.jpg, c:\temp\photo3,jpg

All one string in the PHOTO field, separated by commas.

I want to strip out each hyperlink and update 9 Hyperlink fields in the feature class: [HYPERLINK1], [HYPERLINK2], [HYPERLINK3]….[HYPERLINK9].

I thought it would be easy going something like this:

with arcpy.da.UpdateCursor(fc, ['PHOTOS', 'HYPERLINK1', 'HYPERLINK2', 'HYPERLINK3', 'HYPERLINK4', 'HYPERLINK5', 'HYPERLINK6', 'HYPERLINK7', 'HYPERLINK8', 'HYPERLINK9']) as cursor:
    for row in cursor:
        row[1] = row[0].split(",")[0]