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

timdunlevie1 — Wed, 08 Aug 2018 07:30:32 GMT

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]
        row[2] = row[0].split(",")[1]
        row[3] = row[0].split(",")[2]
        row[4] = row[0].split(",")[3]

etc...
cursor.updateRow(row)

But I'm getting an out of index range as the [PHOTOS] field has some nulls.

And also the [PHOTO] field can have between NULL and 9 Hyperlink strings separated by commas.

So the above code would work if there were 9 strings separated by commas.

Is there a way to get around this?

ArcGIS v10.6, windows 10

Thanks

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

DanPatterson_Retired — Sun, 12 Dec 2021 09:28:01 GMT

As an example of one way to test.

rows = ["C:\temp\photo1.jpg, c:\temp\photo2.jpg, c:\temp\photo3,jpg",
        None,
        "C:\temp\photo4.jpg, c:\temp\photo5.jpg, c:\temp\photo6,jpg",
        "etc", 
        None]
        

rs = [[str(i).split(","), "no split"][i is None] for i in rows]

rs
Out[20]: 
[['C:\temp\\photo1.jpg', ' c:\temp\\photo2.jpg', ' c:\temp\\photo3', 'jpg'],
 'no split',
 ['C:\temp\\photo4.jpg', ' c:\temp\\photo5.jpg', ' c:\temp\\photo6', 'jpg'],
 ['etc'],
 'no split']‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Now where it says "no split" you could put in a list of empty values equal to the length of your photo list or even just None.

You would have to show what you have so far in your code to make more suggestions

topic Arcpy - Stripping out strings in a field seperated by comma (with nulls) in Python Snippets Questions

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

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