I've obtained a KML and converted it to a points layer, but the values for each point appear to be hidden in the column

enter image description here

In the picture, the value of interest is quantity "1.1" - I'm not really sure how or why the values appear that way (the kml was exported from Matlab), and it seems like something that could be done with python code, although that's a little outside my expertise.

Any suggestions?


1 Answer 1


Assuming the HTML wrapped around the value you want is the same in every row, the following simple expression in Field Calculator should work.

First, create a destination field named here NewField, with data type 'double'. Then open Field Calculator and use the following expression:

NewField = !PopupInfo![70:-4].strip()

This slices out the first 70 and last 4 characters, then .strip() removes any leftover whitespace. What's left is coerced to a number by the output field's datatype.

Note that you may need some null handling if that 'Value:' is ever missing e.g. Converting Text Field to Numeric in ArcGIS Pro?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.