EditPlus中的正则表达式 实战(1)(2)

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;;

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

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

EditPlus中的正则表达式 实战(1)

先手动整理下格式去掉空格

然后替换

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

替换项输入:    \1=\1

语义分析:

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/wjssdd.html