topic Re: Calculate Field issue from Python 2 to 3 in Data Management Questions

Calculate Field issue from Python 2 to 3

Brian_McLeer — Mon, 05 Apr 2021 18:02:51 GMT

In trying to upgrade code from Python 2 to 3, the below code broke for a calculate field that functioned in 2.x. I tried putting double quotes around the (' & ') based on some searching, but did not do the trick.

!FullName!.split(' & ')[1].split('/')[0]

The error is:

ERROR 000539: Traceback (most recent call last):
File "<expression>", line 1, in <module>
IndexError: list index out of range
Failed to execute (Calculate Field (4)).

Re: Calculate Field issue from Python 2 to 3

DanPatterson — Mon, 05 Apr 2021 18:28:28 GMT

check your data, it means that one of the splits doesn't yield what you expect.

You want the 2nd portion from the first split and the first from the second split.

If you have an entry the doesn't contain "blah & Blah/done" with an " & "and a "/" then it will fail.

One possible problem is the extra spaces around the ampersand. "&" is very different from " & "

Re: Calculate Field issue from Python 2 to 3

DavidPike — Mon, 05 Apr 2021 18:35:49 GMT

Agree with Dan, this is a data issue and not python version related. It even have 2 spaces either side of the &, is that intended?

Re: Calculate Field issue from Python 2 to 3

JoeBorgione — Mon, 05 Apr 2021 19:22:28 GMT

Here's another vote for a data issue; I won't even go into my usual tirade of special characters in free text fields. You've already discovered one of the reasons I don't like them....