EditPlus 正则表达式 实战_1

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

如上代码要编写成如下格式:

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 = 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=null;
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 = ONE;;
entity.QIAJIJJ_TWO = 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.NIAOCHUANGGUIQT = NIAOCHUANGGUIQT;;
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=null;
entity.FT4=null;
entity.TT3=null;
entity.TT4=null;
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 = RAD;;
entity.ZFQTJZS_RAD = RAD;;
entity.QITAGRS_RAD = 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 = YONGHUBH;;
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;;

在没用这个方式之前我手动一个一个替换来达到目的,数量比较少的情况下手动来的快.

现在系统字段有几百个的时候,这显然不是明智的办法.用正则来达到手动替换更体现了我们的价值.

先手动整理下格式去掉空格
然后替换
查找项输入:   ([A-Z]*[A-Z])=(null)
替换项输入:    \1=\1

语义分析:

([A-Z]*[A-Z])=(null) 等同于 [A-Z]*[A-Z] = null  加上"()"为分组的意思

([A-Z]*[A-Z])   为组1  语法为 \1 代表分组1

(null)              为组2 语法为 \2 代表分组2

 \1=\1  即上面公式替换为下面的公式,下面公式为上面公式中,分组1=分组1 这种格式.

[A-Z]*[A-Z] = null  类似 字母开头中间无限字母结束 加上 "=null" 的都是符合要求的.

拓展练习:

1.上面操作已经替换成功后,做个可逆操作正则表达式还原回去.

查找项输入:   ([A-Z]*[A-Z])=([A-Z]*[A-Z])
替换项输入:   \1=null

2.删除注释诸如

///预约日期
entity.YUYUERQ=YUYUERQ;
///尿蛋白
entity.NIAODANB=NIAODANB;
///血糖
entity.XUETANGPJ=XUETANGPJ;
///检查单位
entity.JIANCHADWBM=JIANCHADWBM;
///检查结果
entity.JIANCHAJG=JIANCHAJG;
///检查结果描述
entity.JIANCHAJGMS=JIANCHAJGMS;

查找项输入:   [/][/][/].*
替换项输入:   输入空 然后 右键删除空行即可

参考文献:

[1]http://blog.csdn.net/paul50060049/article/details/51714941

[2]http://www.cnblogs.com/Mainz/archive/2009/03/14/1411359.html

[3]http://baike.baidu.com/link?url=pj1kZ01huskKhy5z4lDmqa3LJJjOazGGE86ICe4FBLQcxHwPpz_RjMO8CE55uzhvBRjY-NJTN-mBeLL2FF_52Hm4ML_m76jDq53JCA3A2Z0fQ8SrFURXOz6i4kVwE6icUX877uXWpkarXGc_pR0O1K