UNIX for Beginners Questions & Answers

Please, please, please - with your next problem, apply utmost care from the beginning, and start with the ENTIRE picture, provide sufficient info and representative data samples, and DON'T change goals!


You can pipe your above result through another awk script for creating the SQL insert statement, but irrespective of the TOINSTANCETYPE as it is not known in the result:

Code:

awk -f ... |
awk '{IX[$1]; VAL[$1,NR%2] = $2} END {for (x in IX) print "INSERT INTO", x, "values (\"" VAL[x,1] "\" , \"" VAL[x,0] "\");"}'
INSERT INTO EPIC values ("DID" , "PROJECT_NAME");
INSERT INTO SQ_EPIC values ("DID" , "PROJECT_NAME");

You could even try to implement the "insert" creation into the first awk script; this is left as an exercise to the reader.