系列文章: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()); 因為不符合「右邊是純字段名」的規則而不會被匹配,替換後仍需手工處理。這也說明寫正則前先看清數據邊界,比事後返工更省事。