Using the .split() to grab attribute from KMZ

Question

Hi everyone, I am trying to use the .split() function on a string and keep gettings errors. The field is the popup information from a converted KMZ and is called PopupInfo. The code I am trying to use is: !PopupInfo!.split("
")[14] but am getting Error 000539 and is saying "IndexError: list index out of range". The calculation will run fine if 14 is swapped out for 0 or -1 to get the first or last section. I am counting 27 sections if it is being broken at each "
". I've tried finding and replacing all of the
's with a dash or underscore but the calculation still fails with anything other than 0 or -1. The text string that I am trying to pull from looks something like this: US20 EB

FID 57
RampDate 9/30/2013
RouteId 161
RouteName US20 EB
TownId 314
TownName Watertown
IsMissingR False
IsMissingS False
IsMissingC True
InspNotes
DistrictId 6
LegacyID 335
status 6
StatusText Deficient
DstrctRank 669
deficient -1
GlobalID {C4BBAA58-9DFE-4953-AC74-FF3448002388}
created_us
created_da
last_edite DAVID.DINOCCO
last_edi_1 10/17/2017
ReInspectn 0
AssetID
ProgNotes
Rank 669 I would be trying to field calc a different field with the LegacyID from this PopupInfo. Is there a problem with this string that is causing the index errors? The lengths at both ends are never the same so I can't trim off the ends. Thanks for the help! Tim

Arne_Gelfert · Answer

Glad it worked. Mark is as Correct.

Tim-Woodfield · Answer

Figured it out! One of my rows had an empty PopupInfo field so it was failing because there weren't enough indexes. So yes you were right that the index was only a length of 1. I only selected the features with the PopupInfo filled out and it worked.

Thanks!

Tim-Woodfield · Answer

Figured it out! One of my rows had an empty PopupInfo field so it was failing because there weren't enough indexes. So yes you were right that the index was only a length of 1. I only selected the features with the PopupInfo filled out and it worked.

Thanks!