File ATable SAPSR3./1BEA/BBEA_BDH has no BasicFile LOB columnsTable SAPSR3./1BEA/BBEA_BDI has no BasicFile LOB columnsTable SAPSR3./1BEA/BBEA_DLI has no BasicFile LOB columnsTable SAPSR3./1BEA/CNPL_PDL has no BasicFile LOB columnsTable SAPSR3./1BEA/CNPL_PLH has no BasicFile LOB columnsTable SAPSR3./1BEA/CNPL_PLI has no BasicFile LOB columnsSAPSR3.RSEUMOD has more than 255 columnsFile BSAPSR3.TERCL2SAPSR3.TERCL3SAPSR3.CRM_ACE_UCCSAPSR3.CRMIOBJCONTSAPSR3.CRMORDERCONTSAPSR3.CRMD_WEBREQ_CONTSAPSR3.CRMIBASECONTSAPSR3.CRMD_UIF_SYSINDXSAPSR3.CRMISMCONTI need to compare the 2nd column from FileA to FileB. If not found, I must print the entire line of fileA into new fileC otherwise (if found) then print the entire line along with concatenated string as found.Also from File B, the 1st column must be compared with FileA 2nd column. If not found ,then the result of searching this string (1st column of fileB) concatenated with Need to be Analysed must be printed into fileC.
comparing column values between two Unix files
linux;text processing
use the amazing tool awk:awk 'FNR==NR{a[$2]=$3;next}{print $0,a[$2]?a[$2]:NeedToBeAnalayzed}' fileA fileB > fileC