Hi Sam - no I haven't found a more elegant solution to searching/replacing...I would think there's a programmatic solution, but I don't have that much experience - anyone?
Any news on this front?
We have this great KML file with all sorts of very useful data in the HTML popup. However it's all stored in the popup field in the converted point file and can not be read unless copied and pasted into a text editor of some kind.
Looking for a python script or something to get this info out of the single field the proper attribute table format using multiple columns. I believe it's currently stored as HTML-formatted code stored in a text field.
How do you parse through this stuff!?!?! How have people been accomplishing this task?
If the KML/Z file has a schema object then the Data Interoperability extension will create a feature class with a properly typed schema with attributes. If you have to resort to Python then you'll need to parse the HTML with something like BeautifulSoup.
That is great insight. Thanks for helping me solve this once and for all.
I know this is all in the help docs, but sometimes they get too convoluted and this is a much easier forum to get right to the solution.
Happy mapping, Cheers!