awk,该怎么解决

2012-03-06

awkSQL codeawk {print exec DmsPerfDB..UpdateFourGroupSubType $0 \ngo\n} temp.txt | sed s/a/a

awk

SQL code

awk '{print "exec DmsPerfDB..UpdateFourGroupSubType "$0" \ngo\n"}' temp.txt | sed "s/a/a/"  >>query.sql 结果:exec DmsPerfDB..UpdateFourGroupSubType   NE40E-81|Tunnel0/0/193   goexec DmsPerfDB..UpdateFourGroupSubType  NE40E-81|Tunnel0/0/193   goexec DmsPerfDB..UpdateFourGroupSubType  NE40E-81|Tunnel0/0/193   go怎么能变为exec DmsPerfDB..UpdateFourGroupSubType   'NE40E-81|Tunnel0/0/193'   goexec DmsPerfDB..UpdateFourGroupSubType  'NE40E-81|Tunnel0/0/193'   goexec DmsPerfDB..UpdateFourGroupSubType  'NE40E-81|Tunnel0/0/193'  go

[解决办法]

C/C++ code

awk '{print "exec DmsPerfDB..UpdateFourGroupSubType "'\''"$0"'\''" \ngo\n"}' temp.txt | sed "s/a/a/"  >>query.sql