UltraEdit如何将不同的数据通过正则表达式替换为统一的数据

Question

select @areaid = id
from area
where areaname = "新乡市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','78','0','123','163','88','255','新乡市')
select @areaid = id
from area
where areaname = "洛阳市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','7','0','123','163','7','255','洛阳市')
select @areaid = id
from area
where areaname = "洛阳市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','64','0','123','163','77','255','洛阳市')
select @areaid = id
from area
where areaname = "洛阳市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','5','0','123','163','6','255','洛阳市')
select @areaid = id
from area
where areaname = "洛阳市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','4','0','123','163','4','255','洛阳市')
select @areaid = id
from area
where areaname = "平顶山市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','33','0','123','163','63','255','平顶山市')
select @areaid = id
from area
where areaname = "漯河市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','230','0','123','163','255','255','漯河市')
select @areaid = id
from area
where areaname = "周口市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','207','102','123','163','217','255','周口市')
select @areaid = id
from area
where areaname = "周口市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','207','101','123','163','207','101','周口市')
select @areaid = id
from area
where areaname = "周口市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','193','0','123','163','207','100','周口市')
select @areaid = id
from area
where areaname = "南阳市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','188','60','123','163','188','60','南阳市')
select @areaid = id
from area
where areaname = "三门峡市'
insert into IPAddress(startA,startB,startC,startD,endA,endB,endC,endD,AreaID)
values
('123','163','183','0','123','163','187','255','三门峡市')

括号中的'某某市'同时替换成@areaid
文本中还有其他的'**市'要同时替换成@areaid：'上海市'、'北京市'等
这里有（新乡市、三门峡市、南阳市、周口市、漯河市、平顶山市、洛阳市）这几个

Answer 1

你是 只要替换 括号中的 那些 城市 名 是吧
替换规则就是替换 后面是 单引号和右括号 的 城市

使用ultraDdit 的替换功能
查找项写 (周口市|南阳市|新乡市|洛阳市)(?='\)) 城市我只写了几个，其他自己添加吧
替换为写 @areaid

底下引擎 选 perl 吧
然后 点全部替换 应该就可以了

追问

测试成功了！谢谢。只是自己添加可能要点时间了，呵呵