Search Results

Awesome !! Working perfectly. Thank you very much for your help.

Here are the input files and expected output

file1
Adrfld,category
PO BOX,A
POST,A
avenue,A
business,X
bus terminus,A
PO BOX,A

file2
Adrptrn,active,blankrule,cntry
ave,y,n,usa...

Yes, the Active flag will always be 'Y' , but there are other columns on file2 (apart from Adrpatern,Activeflg) that have to be carried out on the output as is for down stream processing. Is there a...

Thanks again for the detailed explanation!!

one point i missed out during the initial post is that there can be max of 2 trailing spaces in the pattern file (file 2) represented by ##. I tried...

Thanks a ton for your help !!! its working perfectly fine. As im new to unix, appreciate if you could explain the solution and also suggest books to learn awk. Many thanks.

Hi,

How to check if a string on file2 exactly matches with a part or complete string on file1, and return a match indicator based on some match rules.
1) only records on file1 with category A...