1,543
社区成员
发帖
与我相关
我的任务
分享
awk '{print "exec DmsPerfDB..UpdateFourGroupSubType "$0" \ngo\n"}' temp.txt | sed "s/a/a/" >>query.sql
结果:
exec DmsPerfDB..UpdateFourGroupSubType NE40E-81|Tunnel0/0/193
go
exec DmsPerfDB..UpdateFourGroupSubType NE40E-81|Tunnel0/0/193
go
exec DmsPerfDB..UpdateFourGroupSubType NE40E-81|Tunnel0/0/193
go
怎么能变为
exec DmsPerfDB..UpdateFourGroupSubType 'NE40E-81|Tunnel0/0/193'
go
exec DmsPerfDB..UpdateFourGroupSubType 'NE40E-81|Tunnel0/0/193'
go
exec DmsPerfDB..UpdateFourGroupSubType 'NE40E-81|Tunnel0/0/193'
go
awk '{print "exec DmsPerfDB..UpdateFourGroupSubType wqmgxj"$0"wqmgxj \ngo\n"}' temp.txt | sed "s/wqmgxj/\'/" | sed "s/wqmgxj/\'/" >>query.sql
awk '{print "exec DmsPerfDB..UpdateFourGroupSubType "'\''"$0"'\''" \ngo\n"}' temp.txt | sed "s/a/a/" >>query.sql
awk '{print "exec DmsPerfDB..UpdateFourGroupSubType \'"$0"\' \ngo\n"}' temp.txt | sed "s/a/a/" >>query.sql