UNIX for Dummies Questions & Answers

}' input_file

}'reportfinal.txt

}' reportfinal.txt

/usr/xpg4/bin/awk '

/usr/xpg4/bin/awk'

sinlga
e34f,n,Mon,Aug,19,,2013,on
ggi11
ggi11,n,Thu,Jul,12,,2012,on
hca05
hca05,n,Mon,Apr,4,,2011,on,
r45fv
r45fv,n,Fri,Feb,7,2014,16:5
e43vg,
4er34,n,Tue,Aug,21,,2012,on
rt4566
rt4566,n,Tue,Nov,12,2013,12:

program1:
 
#!/bin/ksh
load data
infile 'userreport.txt'
INSERT INTO lastlogon
FIELDS TERMINATED BY ','
(
userid
Day
Month
Date
year )
 
program 2:
 
#!/bin/ksh
filename=userreport.txt
while IFS=, userid Day Month Date year
do
INSERT INTO lastlogon
(userid, Day, Month, Date, year)
values(  ................)

loaddata.ksh[2]: load:  not found
+ infile userreport.txt
loaddata.ksh[3]: infile:  not found
+ INSERT INTO lastlogon
loaddata.ksh[4]: INSERT:  not found
+ FIELDS TERMINATED BY ,
loaddata.ksh[5]: FIELDS:  not found
+ userid
loaddata.ksh[7]: userid:  not found
+ Day
loaddata.ksh[8]: Day:  not found
+ Month
loaddata.ksh[9]: Month:  not found
+ Date
loaddata.ksh[10]: Date:  not found
+ year
loaddata.ksh[11]: year:  not found

#!/bin/ksh
filename=userreport.txt
while IFS=, read
do
INTO lastlogon
done
~

+ filename=userreport.txt
+ read
+ IFS=,

+ filename=userreport.txt
+ read
+ IFS=,
+ INTO lastlogon
loaddata1.ksh[5]: INTO:  not found
+ read
+ IFS=,

#!/bin/ksh
file="yourfile"
while read line
do
	echo "$line"
done <"$file"

#!/bin/bash
file="yourfile"
while IFS= read -r line
do
	echo "$line"
done <"$file"

#!/bin/bash
file="yourfile"
while IFS= read -r f1 f2 f3 f4 f5 f6 f7
do
        # display fields using f1, f2,..,f7
        echo "$f1 $f7 $f6"
done <"$file"