Hi
I am using below awk command to load text file data into table
awk '/ n /{print "insert into lastlogon values("$1", "$3", "$4", "$5", "$6")"}
' userreport.txt
but when I run its showing below O/P
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)
but the data is not loadin into table due to single quotes. The actual data should load with quotes as shown below.
insert into lastlogonvalues('ap238d', 'Fri', 'Feb', 14, '2014')
how I could load data with quotes with awk.