DIV CSS 佈局教程網

EditPlus 正則實戰(2):把 entity 賦值批量轉成 XML 節點
編輯:關於JavaScript     

系列文章:EditPlus 中的正則表達式實戰 (1) ~ (6),本篇是第二篇。

延續上一節的思路,這次要處理的目標是:把一大批 entity.XXX=XXX; 形式的賦值語句,轉換成 <XXX>1</XXX> 這樣的 XML 節點寫法。這種需求在對接老系統的WebService 接口時特別常見。

原始代碼(節選)

 #region
 entity.JIANCHARQ=JIANCHARQ;
 entity.YUYUERQ=YUYUERQ;
 entity.NIAODANB=NIAODANB;
 entity.XUETANGPJ=XUETANGPJ;
 entity.JIANCHADWBM=JIANCHADWBM;
 entity.JIANCHAJG=JIANCHAJG;
 entity.JIANCHAJGMS=JIANCHAJGMS;
 entity.MOCIYJ=MOCIYJ;
 entity.YUCHANQI=YUCHANQI;
 entity.SHOUJIANYZ=SHOUJIANYZ;
 entity.YUNCI=YUNCI;
 entity.CHANCI=CHANCI;
 entity.SHOUJIANYT=SHOUJIANYT;
 entity.CHUXUE=CHUXUE;
 entity.JUTU=JUTU;
 entity.FARE=FARE;
 entity.BINGDUGR=BINGDUGR;
 entity.YUNQIANFBYY=YUNQIANFBYY;
 entity.RENSHENGYCQK=RENSHENGYCQK;
 entity.SHENGAO=SHENGAO;
 entity.TIZHONG=TIZHONG;
 entity.GONGGAO=GONGGAO;
 entity.JICHUSZY=JICHUSZY;
 entity.XIN=XIN;
 entity.XINXS=XINXS;
 entity.FEI=FEI;
 entity.FEIXS=FEIXS;
 entity.JICHUSSY=JICHUSSY;
 entity.FUKEJC=FUKEJC;
 entity.YINDAOY=YINDAOY;
 entity.YINDAOYXS=YINDAOYXS;
 entity.GONGJINGY=GONGJINGY;
 entity.GONGJINGYXS=GONGJINGYXS;
 entity.SHUANGYDZG=SHUANGYDZG;
 entity.SHUANGYDZGXS=SHUANGYDZGXS;
 entity.ZIGONGJL=ZIGONGJL;
 entity.ZIGONGJLXS=ZIGONGJLXS;
 entity.FUJIANZW=FUJIANZW;
 entity.FUJIANZWXS=FUJIANZWXS;
 entity.GONGGAOFH=GONGGAOFH;
 entity.ZIGONGXS=ZIGONGXS;
 entity.QITAFKJCXS=QITAFKJCXS;
 entity.XUEHONGDB=XUEHONGDB;
 entity.NIAODANBPJ=NIAODANBPJ;
 entity.NIAOTANGPJ=NIAOTANGPJ;
 entity.JIATAIDB=JIATAIDB;
 entity.GPT_ALTPJ=GPT_ALTPJ;
 entity.ABOXUEXING=ABOXUEXING;
 entity.MEIDU=MEIDU;
 entity.MEIDUJC=MEIDUJC;
 entity.FMEIDUJC=FMEIDUJC;
 entity.FMEIDU=FMEIDU;
 entity.CHANQIANSC=CHANQIANSC;
 entity.HIV=HIV;
 entity.YGBMKYDX=YGBMKYDX;
 entity.BAIDAI=BAIDAI;
 entity.GONGXINGT=GONGXINGT;
 entity.JUXIBBD=JUXIBBD;
 entity.FENGZHENBD=FENGZHENBD;
 entity.SHIYANSJCQT=SHIYANSJCQT;
 entity.SHIYANSJCQTJG=SHIYANSJCQTJG;
 entity.GAOWEIYS=GAOWEIYS;
 entity.GAOWEIXX=GAOWEIXX;
 entity.CHULIZD=CHULIZD;
 entity.GAOWEIBM=GAOWEIBM;
 entity.YIGANKY=YIGANKY;
 entity.BINGGAN=BINGGAN;
 entity.YESUAN=YESUAN;
 entity.TIEDANB=TIEDANB;
 entity.B12=B12;
 entity.DANCHUNPZBZ=DANCHUNPZBZ;
 entity.FUZHUSZ=FUZHUSZ;
 entity.JIANCHAYS=JIANCHAYS;
 entity.RHXUEXING=RHXUEXING;
 entity.RPRJC=RPRJC;
 entity.DIDU=DIDU;
 entity.GAOWEIDJ=GAOWEIDJ;
 entity.GAOWEIPFVALUE=GAOWEIPFVALUE;
 entity.LURUR=LURUR;
 entity.JIANCHADW=JIANCHADW;
 entity.YINDAOFM=YINDAOFM;
 entity.POUGONGC=POUGONGC;
 entity.XIANBINGS=XIANBINGS;
 entity.XIANBINGSXS=XIANBINGSXS;
 entity.JIWANGS=JIWANGS;
 entity.JIWANGSXS=JIWANGSXS;
 entity.BCRSZYYCQK=BCRSZYYCQK;
 entity.BCRSZYYCQKXS=BCRSZYYCQKXS;
 entity.BCRSZYYCQKXSMC=BCRSZYYCQKXSMC;
 entity.BCHYFS=BCHYFS;
 entity.TIZHONGZS=TIZHONGZS;
 entity.XINLV=XINLV;
 entity.XINL=XINL;
 entity.XINZANGZY=XINZANGZY;
 entity.XINZANGZYXS=XINZANGZYXS;
 entity.QITAYC=QITAYC;
 entity.QITAYCXS=QITAYCXS;
 entity.WAIYIN=WAIYIN;
 entity.WAIYINXS=WAIYINXS;
 entity.YINDAOQJD=YINDAOQJD;
 entity.YINDAOFMW=YINDAOFMW;
 entity.QIAJIJJ_ONE=QIAJIJJ_ONE;
 entity.QIAJIJJ_TWO=QIAJIJJ_TWO;
 entity.DICHIWJ=DICHIWJ;
 entity.CHUKOUHJ=CHUKOUHJ;
 entity.BAOXIBJS=BAOXIBJS;
 entity.XIEXIAOBJS=XIEXIAOBJS;
 entity.XUECHANGGUIQT=XUECHANGGUIQT;
 entity.NIAOTANG=NIAOTANG;
 entity.NIAOTONGT=NIAOTONGT;
 entity.NIAOQIANX=NIAOQIANX;
 entity.NIAOBAIXQ=NIAOBAIXQ;
 entity.NIAOCHANGGUIQT=NIAOCHANGGUIQT;
 entity.XUEQINGGBZAM=XUEQINGGBZAM;
 entity.XUEQINGGCZAM=XUEQINGGCZAM;
 entity.BAIDB=BAIDB;
 entity.ZONGDANHS=ZONGDANHS;
 entity.JIEHEHS=JIEHEHS;
 entity.XUEQINGJQ=XUEQINGJQ;
 entity.XUENIAOSD=XUENIAOSD;
 entity.YINDAOFMWXS=YINDAOFMWXS;
 entity.SHAYANYYT=SHAYANYYT;
 entity.LINQIEJJC=LINQIEJJC;
 entity.YIGANWX=YIGANWX;
 entity.YIXGYBMKT=YIXGYBMKT;
 entity.YIXGYEKY=YIXGYEKY;
 entity.YIXGYEKT=YIXGYEKT;
 entity.YIXGYHXKT=YIXGYHXKT;
 entity.BCHAO=BCHAO;
 entity.XINDIANTU=XINDIANTU;
 entity.JIAZHUANGXIANGN=JIAZHUANGXIANGN;
 entity.TSH=TSH;
 entity.FT3=FT3;
 entity.FT4=FT4;
 entity.TT3=TT3;
 entity.TT4=TT4;
 entity.ATG=ATG;
 entity.ATPO=ATPO;
 entity.GONGJINGTLXBJC=GONGJINGTLXBJC;
 entity.ZONGTIPG=ZONGTIPG;
 entity.BAOJIANZD=BAOJIANZD;
 entity.BAOJIANZDMS=BAOJIANZDMS;
 entity.YOUWUZHUANZHEN=YOUWUZHUANZHEN;
 entity.ZHUANZHENYUANYIN=ZHUANZHENYUANYIN;
 entity.ZHUANZHENJJBH=ZHUANZHENJJBH;
 entity.ZHUANZHENJJ=ZHUANZHENJJ;
 entity.ZHUANZHENKS=ZHUANZHENKS;
 entity.ZHIYE=ZHIYE;
 entity.MINZU=MINZU;
 entity.WENHUACD=WENHUACD;
 entity.MINZUMC=MINZUMC;
 entity.SFYUNFUJZS=SFYUNFUJZS;
 entity.YICHUANXJBS=YICHUANXJBS;
 entity.YICHUANXJBSXS=YICHUANXJBSXS;
 entity.JINGSHENBBS=JINGSHENBBS;
 entity.JINGSHENBBSXS=JINGSHENBBSXS;
 entity.ZHIZHANG=ZHIZHANG;
 entity.ZHIZHANGXS=ZHIZHANGXS;
 entity.JIXING=JIXING;
 entity.JIXINGXS=JIXINGXS;
 entity.YUNFUQTJZS=YUNFUQTJZS;
 entity.ZFSFJZS=ZFSFJZS;
 entity.ZFYICHUANXJBS=ZFYICHUANXJBS;
 entity.ZFYICHUANXJBSXS=ZFYICHUANXJBSXS;
 entity.ZFJINGSHENBBS=ZFJINGSHENBBS;
 entity.ZFJINGSHENBBSXS=ZFJINGSHENBBSXS;
 entity.ZFZHIZHANG=ZFZHIZHANG;
 entity.ZFZHIZHANGXS=ZFZHIZHANGXS;
 entity.ZFJIXING=ZFJIXING;
 entity.ZFJIXINGXS=ZFJIXINGXS;
 entity.ZFQTJZS=ZFQTJZS;
 entity.GERENS=GERENS;
 entity.XIYAN=XIYAN;
 entity.XIYANXS=XIYANXS;
 entity.YINJIU=YINJIU;
 entity.YINJIUXS=YINJIUXS;
 entity.FUYONGYW=FUYONGYW;
 entity.FUYONGYWXS=FUYONGYWXS;
 entity.YAOWUGMS=YAOWUGMS;
 entity.YAOWUGMSXS=YAOWUGMSXS;
 entity.JIECHUYDYHWZ=JIECHUYDYHWZ;
 entity.JIECHUYDYHWZXS=JIECHUYDYHWZXS;
 entity.JIECHUFSX=JIECHUFSX;
 entity.JIECHUFSXXS=JIECHUFSXXS;
 entity.WAISHANGS=WAISHANGS;
 entity.WAISHANGSXS=WAISHANGSXS;
 entity.QITAGRS=QITAGRS;
 entity.SHOUSHUS=SHOUSHUS;
 entity.FUKESHOUSHUS=FUKESHOUSHUS;
 entity.FUKESHOUSHUSXS=FUKESHOUSHUSXS;
 entity.QITASHOUSHUS=QITASHOUSHUS;
 entity.QITASHOUSHUSXS=QITASHOUSHUSXS;
 entity.CHUCHAONL=CHUCHAONL;
 entity.ZHOUQIOMIX=ZHOUQIOMIX;
 entity.ZHOUQIOMAX=ZHOUQIOMAX;
 entity.JINGQI=JINGQI;
 entity.JINGQIMAX=JINGQIMAX;
 entity.BIYUNS=BIYUNS;
 entity.BIYUNSXS=BIYUNSXS;
 entity.YUNCHANSHI=YUNCHANSHI;
 entity.YUNFUQTJZS_RAD=YUNFUQTJZS_RAD;
 entity.ZFQTJZS_RAD=ZFQTJZS_RAD;
 entity.QITAGRS_RAD=QITAGRS_RAD;
 entity.JIWANGSXSMC=JIWANGSXSMC;
 entity.ZONGTIPGXS=ZONGTIPGXS;
 entity.SFYJSANDBYS=SFYJSANDBYS;
 entity.SFYWRSANDHY=SFYWRSANDHY;
 entity.SFYWTGJC=SFYWTGJC;
 entity.SFYWPGWCL=SFYWPGWCL;
 entity.SFYWFZJC=SFYWFZJC;
 entity.SFYWGWPDANDBJZD=SFYWGWPDANDBJZD;
 entity.SFYWZZANDSF=SFYWZZANDSF;
 entity.FBKH=FBKH;
 entity.FUNVID=FUNVID;
 entity.FUWUJGBH=FUWUJGBH;
 entity.ID=ID;
 entity.TIANBIAOR=TIANBIAOR;
 entity.TIANBIAORQ=TIANBIAORQ;
 entity.XUETANGZHI=XUETANGZHI;
 entity.QITAJIANCHASX=QITAJIANCHASX;
 entity.QTGAOWEIYS=QTGAOWEIYS;
 entity.YONGHUBH=Convert.ToInt32(YONGHUBH.ToString());
 entity.YESUANXX=YESUANXX;
 entity.SFFUYONGYS=SFFUYONGYS;
 entity.FYKSISHISJ=FYKSISHISJ;
 entity.FYQINGK=FYQINGK;
 entity.SFTINHZFY=SFTINHZFY;
 entity.TINGYYY=TINGYYY;
 entity.ZHIZHANGCD=ZHIZHANGCD;
 entity.ZFZHIZHANGCD=ZFZHIZHANGCD;
 entity.SHIFOUWX=SHIFOUWX;
 entity.BAOJIANCH =BAOJIANCH;
 #endregion

目標代碼(節選)

 #region
 <JIANCHARQ>1</JIANCHARQ>
 <YUYUERQ>1</YUYUERQ>
 <NIAODANB>1</NIAODANB>
 <XUETANGPJ>1</XUETANGPJ>
 <JIANCHADWBM>1</JIANCHADWBM>
 <JIANCHAJG>1</JIANCHAJG>
 <JIANCHAJGMS>1</JIANCHAJGMS>
 <MOCIYJ>1</MOCIYJ>
 <YUCHANQI>1</YUCHANQI>
 <SHOUJIANYZ>1</SHOUJIANYZ>
 <YUNCI>1</YUNCI>
 <CHANCI>1</CHANCI>
 <XUEHONGDB>1</XUEHONGDB>
 <HIV>1</HIV>
 <BAIDAI>1</BAIDAI>
 <TSH>1</TSH>
 <BAOJIANCH>1</BAOJIANCH>
 #endregion

中間省略的部分與首尾格式完全一致,替換時會一次性全部生成。

操作步骤

先手動整理格式、去掉多餘空格,讓每行都是緊湊的賦值語句。

查找項輸入:

(entity.)([A-Z0-9_]*[A-Z0-9_])=([A-Z0-9_]*[A-Z0-9_]);

替換項輸入:

<\2>1</\3>

表達式拆解

去掉外層括號後:

entity.[A-Z0-9_]*[A-Z0-9_]=[A-Z0-9_]*[A-Z0-9_];

括號的含義是「分組」,一對括號代表一個分組,對應 \1,第二個分組對應 \2,以此類推。

整條表達式的意思是:查找以 entity. 開頭、點號後面是由大寫字母、數字與下劃線組成的任意長度並以字母數字下劃線結尾的內容,接著跟一個等號,右邊同樣是這類命名,最後以分號結束。

替換時用 \2 取出左邊的字段名作為標籤名,\3 作為閉合標籤,中間固定填 1,就得到了目標格式。

需要注意的是,原始代碼中有一行 entity.YONGHUBH=Convert.ToInt32(YONGHUBH.ToString()); 因為不符合「右邊是純字段名」的規則而不會被匹配,替換後仍需手工處理。這也說明寫正則前先看清數據邊界,比事後返工更省事。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved