How may I extract HTML tables from a column in a shapefile?

Question

I have a shapefile which contains the elements needed for a small HTML table in one of the columns. Each record has a table. An example of the resulting table is attached. This is a sample record:

Is there a good way to convert this column of data into a useful spatial or non-spatial table? Or, should I parse it from what I already have? HTML fragment.html.zip anno_target.jpg cacuts.jpg

SPANID	20
PLACEMENT	underground
OWNER	FIBERLIGHT
DESIGNATED	Backbone
STRANDS	36

TedKowal · Answer

I had to do something like this a real long time ago... I can give you sort of an outline of the steps I did my memory is not that good.... 1. Extract all the html table column to save it as text (all records) (I believe I had to add a unique Id to the column snippet to link upon later I used the field calculator to insert the additional column code Unique ID) 2. I am assuming that the table snippets are valid complete table codes: add [ all your table snippets] to the file. 3. Using excel import html table ... I got this idea from this web site: HTML TABLE TO EXCEL SPREADSHEET

DarrenWiens2 · Answer

I don't think you'll find an out-of-the-box tool to do this for you, so you'll need to parse it yourself. I'd suggest creating new fields in the current table rather than creating a new table for each row, but it may depend on your data.