I have two text files: FileA.txt and FileB.txt. They are tab-delimited.FileA.txt contains transaction-level records.FileB.txt contains a reference/ lookup table.I would like to append columns called Company and CATEGORY in FileB.txt to FileA.txt by matching the contents of Company in FileB.txt to Description in FileA.txt.   To clarify, match & merge should be on the basis of whether or not the contents for Company exist within the character string contained in column called Description in FileA.txt .Any assistance on this would be appreciated.FileA.txtDate    Description Amount1/15/2016   1231 HAMBURGER #1234 Albany NY 24186166001200699400511  -22.543/3/2016    EASTERN FRUIT CO S1 Trenton NJ  -110.932/26/2016   GUMPS* PAPER INC. 999-123-4560 CA   -9.992/16/2016   EASY BURGERS SUPPLIES 01/31 #000741643 PURCHASE FOOD S TRENTON NJ   -10.972/19/2016   FRANKFURTER Stamford CT -14.182/5/2016    CHECKCARD 0141FRANK'S GROCERIES Albany NY 24071056031987159327565   -87.923/11/2016   WIRED PENCIL & PAPER Sacramento NJ  -72.163/18/2016   UNDERWATER MAIL SRVC 654321 800-1234567 DC  -651/31/2016   VOYAGER REAL ESTATE CO . 415 DES:LEASE PYMNT INDN:123 Main St. CO ID:XXXXX999 ACH   -126.651/18/2016   CARD 0101 US BASKETWEAVING ASSOC 123-456-7890 TX 54692166432112345  -2654/18/2016   CARD ACH #89 UNDERWATER MAIL SRVC 654321 800-1234567 DC 6787654320  -250FileB.txtCompany CATEGORYHAMBURGER   FOODFRANKFURTER FOODPAPER INC.  OFFICEWIRED PENCIL & PAPER    OFFICEFRANK'S GROCERIES   GROCEASY BURGERS SUPPLIES   GROCEASTERN FRUIT CO.   GROCUS BASKETWEAVING ASSOC  OFFICEUNDERWATER MAIL SRVC    OFFICEVOYAGER REAL ESTATE REAL ESTATE
Unix - Awk - Matching & Merging Two Files on A Partial Match (Within Character String)
text processing;awk