Shell Programming and Scripting

Code:

awk 'NR==FNR{a[$1]=$5;next}{print a[$0]}' file1 file2

Thanks Bartus,

Sorry!!!! that i couldn't explain my question properly....

I actually want to ask that if my first file is like:
and second file is

then the output must be :

and if first file contains all the rows present in second file it will print the complete 5th row in order as that in 2nd file....

I apologize for my silly mistake.....

I'm having real trouble following your logic there. How does the order get reversed? Why does it print 5342 when 78, uio, and 56 are all absent? Do you really mean the 5th line and only the 5th line?

Try:

Code:

awk 'NR==FNR{a[$1]=$5;next}{print a[$0]?a[$0]:"ABSENT"}' file1 file2

I think I get it...

Code:

awk -v DATA1="datafile1" 'BEGIN {
        COMPLETE=1
        # Read lines like 'fds 21 sdf 32 6432', so A["21"]="6432" etc.
        while(getline <DATA1)
        {
                for(N=1; N<NF; N++)     A[$N]=$NF
                # Save the fifth line.
                if((++L) == 5) LINE=$0;
        }
}

{
        if(A[$1])       print A[$1];
        else
        {
                COMPLETE=0; # Remember if any fields were missing.
                print "ABSENT";
        }
}

END {
        # If no fields were missing, print the complete fifth line.
        if(COMPLETE)    print LINE;
}' < datafile2

Hey corona......

Thanks a lot....it works well

But, I didnt understand that which statement is storing the 5th column of first file.....although u mentioned "# Save the fifth line"....... I tried by replacing 5 by 3 or 2 in ....but it is still giving the same output as in , I need to store 2nd and 5th column data in separate files.

Also, my secondfile has 20 rows of strings, whereas in everyoutput, it is showing 21 rows.....last row is always "ABSENT", all above 20 rows are in desired way..... can u plz figure it out.

---------- Post updated at 12:20 PM ---------- Previous update was at 10:57 AM ----------

Hey Bartus

ur code also works well.......

But, this is also showing the same problem of printing one extra last row printed ABSENT.

i.e, the second file has 20 rows, and first file has 20 or less rows.....so expected outcome is 20 rows only...but instead of that it is showing 21 rows and every time last row is showing "ABSENT"

Can you post output of

Code:

cat -e file2

?