I am working on creating a script that can be used when converting KMZ files to a feature class. I have that part down and am now getting rid of extraneous columns and cleaning up the data. The issue is that when the KMZ is imported, the "PopupInfo" field contains "<br>" and "</br>" characters separating things like type of site, phone number, address, and lat/long.
Education<br>(123) 456-7890</br><br>12345 Road Name Rd., City, ST 12345<br>Location:DD.DDDDDN, DD.DDDDDW
I was trying to think of a way to split the text out into respective columns (type, phone, address, Lat, Long) but for the life of me cannot figure out how to split this in an efficient way. In field calculator I have tried:
and successfully brought over the type but have no idea how to do it with the phone number and addresses.
Is there anyway to split text based on multiple delimiters or can anyone suggest an efficient way to do this?
Thanks in advance!