个人写得正则表达式一例

前端之家收集整理的这篇文章主要介绍了个人写得正则表达式一例前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。


要匹配的文本:

insert into b_kkqp_jgcl (JLBH,HPHM,HPZL,JGSJ,CLSD,ZGXS,ZDXS,CWKC,HPYS,CLLX,JLLX,HDSJ,BZWZDM,SBBH,CDBH,FXBH,TPSL,CLBJ,SHBJ,ZFBJ,SJLY,CCLX,BZ,TJBJ,CSYS,JLLB,XSFX,CSBJ,YZYS,TPLX,XRSJ,URL)
values ('610300001045022016081000035347','陕CT8283',to_date('10-08-2016 00:03:53','dd-mm-yyyy hh24:mi:ss'),22,80,3.00,'0','2',610300,'610300001045',2,'EW',1,null,'127.0.0.1',999,to_date('10-08-2016 00:44:40','/201605/25/08/12345678901-20160525083919-13-1.jpg;');


insert into b_kkqp_jgcl (JLBH,URL)
values ('610300001045032016081000035469','陕CT8136',to_date('10-08-2016 00:03:54',27,3,'NS',to_date('10-08-2016 00:47:09',URL)
values ('610300001045022016081000035325','/201605/25/08/12345678901-20160525083919-13-1.jpg;');

正则表达式:
insert into b_kkqp_jgcl .+\n.+\);\n


分析:

\n : 匹配换行符

):括弧在正则表达式为关键字, ‘)’要写成\)

猜你在找的正则表达式相关文章