I have a file a:
aaa bbb ccc DDD ads zzz caa DDD aba bab cac DAD aad cca cas SFD
and a file b:
DDD 5 DAD 13 SFD 11
I want to add a fifth column to file a based on file b, meaning search the term of column4 of file a in file b and add a fifth column to file a containing the respective value of column2 in file b.
Can you help me?