AnsweredAssumed Answered

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

Question asked by monkey72 on Mar 15, 2016
Latest reply on Mar 15, 2016 by tkowal

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:


<br><br><br> <table border="1" padding="0"> <tr><td>SPANID</td><td>20</td></tr> <tr><td>PLACEMENT</td><td>underground</td></tr> <tr><td>OWNER</td><td>FIBERLIGHT</td></tr> <tr><td>DESIGNATED</td><td>Backbone</td></tr> <tr><td>STRANDS</td><td>36</td></tr>


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?