//http://www.mca.gov.cn/article/sj/xzqh/2020/
var st = document.createElement("script");
st.setAttribute("type", "text/javascript");
st.setAttribute("src", "https://cdn.bootcdn.net/ajax/libs/jquery/3.6.0/jquery.min.js");
document.body.insertBefore(st, document.body.firstChild);
var s = "";
var carr = [0,0];
$("table > tbody > tr[height=19]").each(function(i,o) {
var code = $(o).children("td:eq(1)").text();
var val = $(o).children("td:eq(2)").text();
var ts = code + "-" + val.replace(/[\s]*([\u4e00-\u9fa5]+)$/, "$1") + "-";
if (/^[\u4e00-\u9fa5]+$/.test(val)) {
ts += 0 + "-1";
carr[0] = code;
carr[1] = 0;
} else if (/^[\s]{1}[\u4e00-\u9fa5]+$/.test(val)) {
ts += carr[0] + "-2";;
carr[1] = code;
} else if (/^[\s]{3}[\u4e00-\u9fa5]+$/.test(val)) {
var p = 0;
var l;
for (var i = (carr.length - 1); i >= 0; i--) {
if (carr[i] == "0") continue;
p = carr[i];
l = i + 2;
break;
}
ts += p + "-" + l;
}
if (s.length > 0) s += "\r\n";
s += ts;
});
//编码-名称-父级编号-级别
console.log(s);
替换正则
^([^-]+)-([^-]+)-([^-]+)-(\d+)$
insert into cms_area\(area_code,area_name,parent_code,area_level\) values\($1,'$2',$3,$4\);