求个正则,想在quicker里用一下

动作需求 · 1546 次浏览
临夏开水 创建于 2021-11-11 21:25
 

各位,求个正则表达式,想在quicker里用一下,提取href中的格式为:“base64码|姓名|社名”,每条记录一行,有上千条数据!

谢谢了!

<tr height="18"> 
     <td height="18"><div align="center" class="STYLE1"><a href="https://www.jdhq.cn/fcgi-bin/HuQingTaiZhangQuery.fcgi?SHVCaWFuSGFvPTU3MDAwMDAyNDY4MDg2NTUmU2VsX1hpYW5RdT3B2c/Ez9gmU2VsX1hpYW5nWmhlbj2xsdyr1fImU2VsX1hpbmdaaGVuZ0N1bj2xpNfTtOUmU2VsX1ppUmFuQ3VuPSZVcmxQYXJhbT0mQmlhbkhhbz02MjI5MjEwMTUwMDcwMiZYaW5nWmhlbmdRdUh1YUppQmllPTUmU2hlbmdTaGk9uMrL4MqhJlNoaVpob3U9wdnPxLvY1+XX1NbO1t0mWGlhblF1PcHZz8TP2CZYaWFuZ1poZW49sbHcq9XyJlhpbmdaaGVuZ0N1bj2xpNfTtOUmWmlSYW5DdW49">黄四</a></div></td> 
     <td><div align="center" class="STYLE1">江东省</div></td>  
     <td><div align="center" class="STYLE1">江东市</div></td>  
     <td><div align="center" class="STYLE1">江东县</div></td>  
     <td><div align="center" class="STYLE1">城郊镇</div></td>  
     <td><span class="STYLE1">幸福村</span></td>       
     <td><span class="STYLE1">B-已脱贫户</span></td>       
     <td><span class="STYLE1">韩三社</span></td>       
   </tr>                
   <tr height="18"> 
     <td height="18"><div align="center" class="STYLE1"><a href="https://www.jdhq.cn/fcgi-bin/HuQingTaiZhangQuery.fcgi?SHVCaWFuSGFvPTU3MDAwMDAyNDY4MDg2NTUmU2VsX1hpYW5RdT3B2c/Ez9gmU2VsX1hpYW5nWmhlbj2xsdyr1fImU2VsX1hpbmdaaGVuZ0N1bj2xpNfTtOUmU2VsX1ppUmFuQ3VuPSZVcmxQYXJhbT0mQmlhbkhhbz02MjI5MjEwMTUwMDcwMiZYaW5nWmhlbmdRdUh1YUppQmllPTUmU2hlbmdTaGk9uMrL4MqhJlNoaVpob3U9wdnPxLvY1+XX1NbO1t0mWGlhblF1PcHZz8TP2CZYaWFuZ1poZW49sbHcq9XyJlhpbmdaaGVuZ0N1bj2xpNfTtOUmWmlSYW5DdW49">黄五</a></div></td> 
     <td><div align="center" class="STYLE1">江东省</div></td>  
     <td><div align="center" class="STYLE1">江东市</div></td>  
     <td><div align="center" class="STYLE1">江东县</div></td>  
     <td><div align="center" class="STYLE1">城郊镇</div></td>  
     <td><span class="STYLE1">幸福村</span></td>       
     <td><span class="STYLE1">B-已脱贫户</span></td>        
     <td><span class="STYLE1">韩三社</span></td>       
   </tr>                
   <tr height="18"> 
     <td height="18"><div align="center" class="STYLE1"><a href="https://www.jdhq.cn/fcgi-bin/HuQingTaiZhangQuery.fcgi?SHVCaWFuSGFvPTYyMjkyMTAxNTAwNzA5NyZTZWxfWGlhblF1PcHZz8TP2CZTZWxfWGlhbmdaaGVuPbGx3KvV8iZTZWxfWGluZ1poZW5nQ3VuPbGk19O05SZTZWxfWmlSYW5DdW49JlVybFBhcmFtPSZCaWFuSGFvPTYyMjkyMTAxNTAwNzAyJlhpbmdaaGVuZ1F1SHVhSmlCaWU9NSZTaGVuZ1NoaT24ysvgyqEmU2hpWmhvdT3B2c/Eu9jX5dfU1s7W3SZYaWFuUXU9wdnPxM/YJlhpYW5nWmhlbj2xsdyr1fImWGluZ1poZW5nQ3VuPbGk19O05SZaaVJhbkN1bj0=">张三</a></div></td> 
     <td><div align="center" class="STYLE1">江东省</div></td>  
     <td><div align="center" class="STYLE1">江东市</div></td>  
     <td><div align="center" class="STYLE1">江东县</div></td>  
     <td><div align="center" class="STYLE1">城郊镇</div></td>  
     <td><span class="STYLE1">幸福村</span></td>       
     <td><span class="STYLE1">B-已脱贫户</span></td>         
     <td><span class="STYLE1">张老一社</span></td>       
   </tr>                
临夏开水 最后更新于 2021/11/11

临夏开水 2021-11-11 21:26 :

或帮忙写个正则动作更好

回复内容
紫cm煞 2021-11-12 10:08
#1

DEMO - 动作信息 - Quicker (getquicker.net)


不用正则,你这个是网页HTML格式,用网页提取就可以了, 我做了一个,不清楚你的64是不是就是?后面的数据,你可以自己调整一下, 数据输出采用的是选择txt文件打开的方式。

临夏开水 2021-11-12 16:55 :

非常感谢,已经稍做修改用到了项目中,解决了上千条数据处理,提取到了有用的信息。正则的话,数据量大了就容易出问题。再次感谢。

回复主贴