Shell Programming and Scripting

i have this file

11 tony tony
12 john john 0
13 nick nick 20
14 mary mary 40

i want to display the file like

tony tony missing
john john 0 Failed
nick nick Failed
mary mary 40

if there is no mark for a name flag it as missing ,mark <40 flagged as failed

i came up with

awk ' {no=$4
if (!no){
print $2,$3,"MISSING"
}
else {
if (no>=40){
print $2,$3,$4
}
else {
print $2,$3,$4,"Failed"
}
}
}' file

but the output is :

tony tony missing
john john missing
nick nick Failed
mary mary 40

why it is displaying missing after john while there is mark "0" for him?

Code:

{$1=""; $0=$0}
NF < 3 {print $0, "missing"; next }
$NF < 40 { print $0, "Failed"; next }
{print $0}

i dont want the space in front..
but how

Code:

NF < 4 {print $2, $3, "missing"; next }
{ print $2, $3, $4, ($NF < 40) ? "Failed" : ""}

yeap tried that and worked just great

thanx.you've been really helpfull

cheers

I modifed your original script. It is working ...

Code:

awk ' {no=$4
if (length(no)== 0 ){
print $2,$3,"MISSING"
}
else {
if (no>=40){
print $2,$3,$4
}
else {
print $2,$3,$4,"Failed"
}
}
}' file1

yeap ..good point..this worked as well

thank you both