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