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