Match words and fetch data in front of it in second column

view full story

http://www.unix.com – Hi all, I have 2 files one file contain data like this in one column Code: AST3 GSTY4 JST3 second file containign data like this in 2 columns Code: AST3(PAXXX),GSTY4(PAXXY)              it is used in diabetes KST4                                                    it is used in blood pressure JST3                                  (HowTos)