要匹配的文本:
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 : 匹配换行符
):括弧在正则表达式为关键字, ‘)’要写成\)