|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
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; |
如上代码要编写成如下格式:
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
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.删除注释诸如
|
1
2
3
4
5
6
7
8
9
10
11
12
|
///预约日期 entity.YUYUERQ=YUYUERQ; ///尿蛋白 entity.NIAODANB=NIAODANB; ///血糖 entity.XUETANGPJ=XUETANGPJ; ///检查单位 entity.JIANCHADWBM=JIANCHADWBM; ///检查结果 entity.JIANCHAJG=JIANCHAJG; ///检查结果描述 entity.JIANCHAJGMS=JIANCHAJGMS; |
查找项输入: [/][/][/].*
替换项输入: 输入空 然后 右键删除空行即可
以上所述是小编给大家介绍的EditPlus中的正则表达式 实战(1)，希望对大家有所帮助，如果大家有任何疑问请给我留言，小编会及时回复大家的。在此也非常感谢大家对服务器之家网站的支持！
原文链接：http://blog.csdn.net/sat472291519/article/details/53389006
