i am having 2 text files
111|rama
222|krishna
333|jaya
and
111|22|43
222|66|42
i want to combine these two text files,the output should be as follows
111|rama|22|43
222|krishna|66|42
333|jaya||
pls help
i am having 2 text files
111|rama
222|krishna
333|jaya
and
111|22|43
222|66|42
i want to combine these two text files,the output should be as follows
111|rama|22|43
222|krishna|66|42
333|jaya||
pls help
There're already numerous similar threads in these forums.
Please, search the forums first!
:wall: I checked it but none will solve my problem
Suryanarayana,
I believe you did not check the forum throughly!!!
However,
awk -F"|" 'NR==FNR { a[$1]=$0;next} $1 in a {print a[$1],$2,$3}' OFS="|" file1 file2
Should work for you.
Well... you should have at least gotten a hint and expanded on it to satisfy your requirement, e.g. this thread.