Shell Programming and Scripting

?_?

Code:

~/unix.com$ cat file1
00AB01/11
43TG22/00
78RC09/34
~/unix.com$ cat file2
78RC09/34 1
45FD11/11 2
00AB01/11 3
43TG22/00 4
~/unix.com$ awk 'NR==FNR{A[$1]=$2;next}$0=$1 OFS A[$1]' file2 file1
00AB01/11 3
43TG22/00 4
78RC09/34 1

dear tukuyomi, i'm following exactly what you wrote and still i get only the column of $1 from file 2

Code:

akm@snoopy:~/temp$ awk 'NR==FNR{A[$1]=$2;next}$0=$1 OFS A[$1]' file2 file1 > file3
akm@snoopy:~/temp$ cat file3
78RC09/34 
45FD11/11 
00AB01/11 
43TG22/00

---------- Post updated at 06:58 AM ---------- Previous update was at 06:48 AM ----------

ok,my bad, i was inserting file1 instead of file2 in the previous awk command...however i still get the comparison results of column $1 successfully but i'm not able to get their corresponding $2 column.

so now i get in the newly file3 after:

Code:

awk 'NR==FNR{A[$1]=$2;next}$0=$1 OFS A[$1]' file2 file1 > file3

Code:

cat file3
00AB01/11 
43TG22/00 
78RC09/34

---------- Post updated at 07:08 AM ---------- Previous update was at 06:58 AM ----------

tukuyomi,

ok, i'll need to update you on that...the command you wrote is correct but for a weird reason this command was not fully functional on an ubuntu machine...i've tried it on cygwin in a windows environment and it worked perfectly well...sounds a bit awkward but ok,..at the very end everything now is ok

thank you!