#!/usr/bin/awk -f

BEGIN {
  FS = ","
  print "BEGIN;";
}
{
  rest = $6 $7;
  gsub("\"", "", rest);
  printf("INSERT INTO office VALUES(%s,%s,%s,%s,%s,'%s');\n",
	 $8, $3, $2, $4, $5, rest);
}
END {
  print "COMMIT;";
}