Shell Programming and Scripting

Hi
i have file f1 like:

xx yy| 123
xx1 yy1| 1234
xx2 yy2|12345


f2 file like:

xx yy| aaa
xx1 yy1| bbb
xx2 yy2|cccc

i would like output is:

xx yy| 123|aaa
xx1 yy1| 1234|bbbb
xx2 yy2|12345|cccc
please help me on this...........

Code:

join -t"|" -j 1 -o 1.1 1.2 2.2 f1 f2

Hi above floor,

Your code is so cute. I have never used it before. Thanks for your good idea.

Anyway, below is my solution using AWK.

code:

Code:

nawk 'BEGIN{OFS=FS="|"}
NR==FNR {t[$1]=$2}
NR!=FNR {$3=$2;$2=sprintf("%s",t[$1]);print}
' f1 f2

Please give me the logic or explain me how it works.
Thanks

awk -F"|" 'NR==FNR {a[$1]=$2} NR!=FNR {print $0,"|",a[$1]}' f2 f1

Explanation:
------------

1) NR=FNR checks for the first file and stores the value of the second column from file "f2" in an array.
a[xx yy]=aaa
a[xx1 yy1]=bbb
a[xx2 yy2]=cccc

2) NR!=FNR checks for the second file and prints all the rows from second file along with the value of the column.

I hope this will be helpful.

Amit

Hi

Have question on this .Want to store 2nd and 3 rd column from file 2 in an array produce the below o/p using the below one but its not working
Ex:
xx yy| 123
xx1 yy1| 1234
xx2 yy2|12345


f2 file like:

xx yy| aaa|100.00
xx1 yy1| bbb|200.00
xx2 yy2|cccc|300.00

i would like output is:

xx yy| 123|aaa|100.00
xx1 yy1| 1234|bbbb|200.00
xx2 yy2|12345|cccc|300.00



awk -F"|" 'NR==FNR {a[$1]=$2=$3} NR!=FNR {print $0,"|",a[$1]}' f2 f1

Thanks,
MR