(1) Manually remove
and open/end tags(2) remove all strings matching
class="tabDetailViewD\w"
(3) replace
with
NULL
(4) replace
<tr>
with
\n\(
(5) replace
</tr>
with
\),
(6) replace
<td>
with
'
(7) replace
</td>
with
',
(8) replace
'NULL'
with
NULL
(9) replace
,\),
with
\),
(10) manually remove the top one or two lines of blank space and table headers
(11) replace
\('\d+',
with
\(
(12) manually replace trailing , with ; on the last line
(13) prepend the following truncate and INSERT statement...
truncate fields_meta_data;
insert into fields_meta_data(
id, name, vname, comments, help, custom_module, type, len, required, default_value, date_modified,
deleted, audited, massupdate, duplicate_merge, reportable, importable, ext1, ext2, ext3, ext4
)
values
Why don't you write a PHP program to upload a file and have it generate the .sql?