regex - awk: comment a SQL statement -


i have huge file lines like

insert mytable (),()... 

i'd replace lines beginning insert mytable by

/* insert mytable (),()... */ 

i know there tons of possibilities, including vim search replace macro, i'd in command line.

here's awk version:

 awk '{ gsub("^(insert.*)","/* & */"); print $0 }' 

this assuming insert first character on line. if there can leading spaces, use instead:

awk '{ gsub("^([[:space:]]*insert.*)","/* & */"); print $0 }' 

this should work non-gnu awk's well. tested on linux , aix.


Comments