UNIX for Dummies Questions & Answers

awk '/ n /{print "insert into lastlogon values("$1", "$3", "$4", "$5", "$6")"}'
userreport.txt

+ awk / n /{print "insert into lastlogon values("$1", "$3", "$4", "$5", "$6")"} userreport.txt
insert into lastlogon values(we34w, Fri, Jan, 3, 2014)
insert into lastlogon values(yyy43, Mon, Aug, 19,, 2013)
insert into lastlogon values(34der, Thu, Jul, 12,, 2012)
insert into lastlogon values(45erf, Mon, Apr, 4,, 2011)
insert into lastlogon values(23erf, Fri, Feb, 7, 2014)
insert into lastlogon values(23wqe, Tue, Aug, 21,, 2012)
insert into lastlogon values(34dw3, Tue, Nov, 12, 2013)
insert into lastlogon values(34ewe, Tue, Jan, 1,, 2013)
insert into lastlogon values(23wwq, Thu, Feb, 20, 2014)

awk '/ n /{print "insert into lastlogon values("$1", "$3", "$4", "$5", "$6")"}
' userreport.txt

insert into lastlogon values(3er45, Mon, Feb, 17, 2014)
insert into lastlogon values(34fe, Thu, Feb, 20, 2014)
insert into lastlogon values(ve3wThu, Feb, 20, 2014)
insert into lastlogon values(v34rfn, Sep, 23, 2013)
insert into lastlogon values(gwed,ue, Feb, 18, 2014)
insert into lastlogon values(swed2n, Jul, 30, 2007)
insert into lastlogon values(wesdc, Aug, 25, 2006)
insert into lastlogon values(wedsa, Feb, 14, 2014)

insert into lastlogonvalues('ap238d', 'Fri', 'Feb', 14, '2014')

awk '/ n /{q="\047";print "insert into lastlogon values("q$1q", "q$3q", "q$4q", "q$5q", "q$6q")"} ' userreport.txt

awk '/ n /{print "insert into lastlogon values(" q $1 q ", " q $3 q ", "q $4 q", "q $5 q", " q $6 q ")"}' q=\' userreport.txt

awk '/ n /{print "insert into lastlogon values(" q$1q, q$3q, q$4q, q$5q, q$6q ")"}' q=\' OFS=", " userreport.txt

awk '/ n /{print "insert into lastlogon values(" q $1, $3, $4, $5, $6 q ")"}' q=\' OFS="', '" userreport.txt

awk '/ n /{print "insert into lastlogon values(" q$1q, q$3q, q$4q, $5, q$6q ")"}' q=\' OFS=", " userreport.txt

insert into lastlogon values('swr34', 'Thu', 'Oct', 25, '2012')
insert into lastlogon values('rerw3', 'Tue', 'Dec', 3, '2013')
insert into lastlogon values('5qsd1', 'Thu', 'Nov', 21, '2013')
insert into lastlogon values('r86r5', 'Thu', 'Oct', 11, '2007')
insert into lastlogon values('7gc51', 'Tue', 'Feb', 4, '2014')
insert into lastlogon values('jp64d', 'Sun', 'Jun', 24, '2012')
insert into lastlogon values('534df', 'Mon', 'Feb', 17, '2014')
insert into lastlogon values('64fd4', 'Thu', 'Feb', 20, '2014')
insert into lastlogon values('64etv', 'Thu', 'Feb', 20, '2014')
insert into lastlogon values('564dd', 'Mon', 'Sep', 23, '2013')
insert into lastlogon values('g64ft7', 'Tue', 'Feb', 18, '2014')
insert into lastlogon values('56gdt', 'Mon', 'Jul', 30, '2007')
insert into lastlogon values(5fyg7', 'Fri', 'Aug', 25, '2006')
insert into lastlogon values('ad496', 'Fri', 'Feb', 14, '2014')

insert into lastlogon values('ad496', 'Fri', 'Feb', 14, '2014')

insert into lastlogon values(se3aa', 'Wed', 'Jun', 30, '2010');
insert into lastlogon values('34s34', 'Tue', 'Mar', 15, '2011');
insert into lastlogon values('34saw', 'Mon', 'Feb', 3, '2014');

;

while read filename
do
awk '/ n /{print "insert into lastlogon values(" q$1q, q$3q, q$4q, $5, q$6q ");"
}' q=\' OFS=", " userreport.txt
done<${filename}

insert into lastlogon values(se3aa', 'Wed', 'Jun', 30, '2010');
insert into lastlogon values('34s34', 'Tue', 'Mar', 15, '2011');
insert into lastlogon values('34saw', 'Mon', 'Feb', 3, '2014');