读书人

请获取表格内的特定数据的正则表达式,

发布时间: 2012-01-11 22:28:46 作者: rapoo

请获取表格内的特定数据的正则表达式,格式如下

请获取表格内的特定数据的正则表达式,格式如下:

<span id=savetext>
<TABLE id="Zkt_ry_jbSt" class="e-01-tbl" onclick="try{sortColumn(event)}catch(e){}" width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#E4E4E4" bordercolordark="#FFFFFF">
<THEAD>
<TR class="e-01-tbl-th-tr">
<TD colspan=1 class="e-01-tbl-th-td" Type="Number" nowrap>序号</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>随机号</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>姓名</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>性别</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>学员号</TD>
<TD colspan=1 class="e-01-tbl-th-td" width="180" nowrap>联系地址</TD>
<TD colspan=1 class="e-01-tbl-th-td" width="180" nowrap>通讯地址</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>单位</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>登记日期</TD>
<TD colspan=1 class="e-01-tbl-th-td" nowrap>操作</TD>
</TR>
</THEAD>


<script LANGUAGE="javascript">
var aryDmPkZkt_ry_jb = new Array(100 *1);
</script>

<tbody>


<TR class="e-01-tr-1" id='Row0' ondblclick="javascript:view();" onMouseOver="javascript:mouseOverRow(this);" onMouseOut="javascript:mouseOutRow(this);" title="徐亨军 已发证 未注销
流水号:330203200800032655
别名: 
" >
<TD colspan=1 class="e-01-td-r"

nowrap>1</TD>
<TD colspan=1 class="e-01-td"

nowrap>330203200800032655</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByXmxyzh('王天一','312345673')" title="显示姓名是王天一,学员证号是312345673的所有学员登记信息" class="prompt_url">王天一</A>
</TD>
<TD colspan=1 class="e-01-td" nowrap>男</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByxyzh('312345673')" title="显示学员证号是312345673的所有学员登记信息" class="prompt_url">312345673</A>
</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>湖北省荆州市金马路</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>金马路203弄6号201室</TD>
<TD colspan=1 class="e-01-td" nowrap><span class="e-01-tbl-th-td">单位</span>1</TD>
<TD colspan=1 class="e-01-td" nowrap>2008-03-28</TD>
<TD colspan=1 class="e-01-td" nowrap>
<select style="width: 120px" onchange="jumpmenu('new',this)" name=menu1>
<option value=# selected> </option>
</select>

</TD>
<SCRIPT LANGUAGE=javascript>
aryDmPkZkt_ry_jb[0]='330203200800032655';
</SCRIPT>
</TR>


<TR class="e-01-tr-2" id='Row1' ondblclick="javascript:view();" onMouseOver="javascript:mouseOverRow(this);" onMouseOut="javascript:mouseOutRow(this);" title="杨卢英 已发证 未注销
流水号:330203200800032652
别名:马自达
" >
<TD colspan=1 class="e-01-td-r"

nowrap>2</TD>
<TD colspan=1 class="e-01-td"

nowrap>330203200800032652</TD>


<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByXmxyzh('马自达','306161181')" title="显示姓名是马自达,学员证号是306161181的所有学员登记信息" class="prompt_url">马自达</A>
</TD>
<TD colspan=1 class="e-01-td" nowrap>女</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByxyzh('306161181')" title="显示学员证号是306161181的所有学员登记信息" class="prompt_url">306161181</A>
</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>浙江省杭州市人文巷16号312室</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>人文巷16号312室</TD>
<TD colspan=1 class="e-01-td" nowrap><span class="e-01-tbl-th-td">单位</span>2</TD>
<TD colspan=1 class="e-01-td" nowrap>2008-03-28</TD>
<TD colspan=1 class="e-01-td" nowrap>
<select style="width: 120px" onchange="jumpmenu('new',this)" name=menu1>
<option value=# selected> </option>
</select>

</TD>
<SCRIPT LANGUAGE=javascript>
aryDmPkZkt_ry_jb[1]='330203200800032652';
</SCRIPT>
</TR>


<TR class="e-01-tr-1" id='Row2' ondblclick="javascript:view();" onMouseOver="javascript:mouseOverRow(this);" onMouseOut="javascript:mouseOutRow(this);" title="陈小霞 已发证 未注销
流水号:330203200800032654
别名: 
" >
<TD colspan=1 class="e-01-td-r"

nowrap>3</TD>
<TD colspan=1 class="e-01-td"

nowrap>330203200800032654</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByXmxyzh('陈宝来','497066129')" title="显示姓名是陈宝来,学员证号是497066129的所有学员登记信息" class="prompt_url">陈宝来</A>
</TD>
<TD colspan=1 class="e-01-td" nowrap>女</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByxyzh('497066129')" title="显示学员证号是497066129的所有学员登记信息" class="prompt_url">497066129</A>
</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>浙江省衢州市柯城区大天街</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>大天街8号502室</TD>
<TD colspan=1 class="e-01-td" nowrap><span class="e-01-tbl-th-td">单位</span>3</TD>
<TD colspan=1 class="e-01-td" nowrap>2008-03-28</TD>
<TD colspan=1 class="e-01-td" nowrap>
<select style="width: 120px" onchange="jumpmenu('new',this)" name=menu1>
<option value=# selected> </option>
</select>

</TD>
<SCRIPT LANGUAGE=javascript>
aryDmPkZkt_ry_jb[2]='330203200800032654';
</SCRIPT>
</TR>
<TR class="e-01-tr-2" id='Row3' ondblclick="javascript:view();" onMouseOver="javascript:mouseOverRow(this);" onMouseOut="javascript:mouseOutRow(this);" title="万振毫 已发证 未注销
流水号:330203200800032663
别名: 
" >
<TD colspan=1 class="e-01-td-r"

nowrap>4</TD>
<TD colspan=1 class="e-01-td"

nowrap>330203200800032663</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByXmxyzh('万天毫','341113039')" title="显示姓名是万天毫,学员证号是341113039的所有学员登记信息" class="prompt_url">万天毫</A>


</TD>
<TD colspan=1 class="e-01-td" nowrap>男</TD>
<TD colspan=1 class="e-01-td" nowrap>
<A href="javascript:listZkByxyzh('341113039')" title="显示学员证号是341113039的所有学员登记信息" class="prompt_url">341113039</A>
</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>骆岗街道王卫社居委</TD>
<TD colspan=1 class="e-01-td" width="180" nowrap>君子街11号407室</TD>
<TD colspan=1 class="e-01-td" nowrap><span class="e-01-tbl-th-td">单位</span>4</TD>
<TD colspan=1 class="e-01-td" nowrap>2008-03-28</TD>
<TD colspan=1 class="e-01-td" nowrap>
<select style="width: 120px" onchange="jumpmenu('new',this)" name=menu1>
<option value=# selected> </option>
</select>

</TD>
<SCRIPT LANGUAGE=javascript>
aryDmPkZkt_ry_jb[3]='330203200800032663';
</SCRIPT>
</TR>
</table>
</span>

想得到以下数据,请问这正则表达式应当如何写
1,330203200800032655,王天一,男,312345673,湖北省荆州市金马路,金马路203弄6号201室,单位1,2008-03-28
2,330203200800032652,马自达,女,306161181,浙江省杭州市人文巷16号312室,人文巷16号312室,单位2,2008-03-28
3,330203200800032654,陈宝来,女,497066129,浙江省衢州市柯城区大天街,大天街8号502室,单位3,2008-03-28
4,330203200800032663,万天毫,男,341113039,骆岗街道王卫社居委,君子街11号407室,单位4,2008-03-28


[解决办法]
(?<=[<](TD|td)[^>]*[>]).*(?=[<]/(TD|td)[>])
[解决办法]
(?<=nowrap>).*?(?=\</TD>)|(?<=class=""prompt_url"">).*?(?=\</A>)

读书人网 >asp.net

热点推荐