How to search 2 separate patterns from a 2nd file.?

Shell Programming and Scripting
1

Hi Guys,

Need your urgent support please. I have a file with 3 separate strings separated by a comma and 2nd file which has a sentence where I can find these 3 strings. I need to find sentences which do not have these strings and maybe redirect it to a 3rd file.

All the 3 strings will occur in a single string and may contain 3 or more characters between them.

1st file

22220107328,internet3g.chinguitel.mr,20140510132035
447412516941,three.co.uk,20140510133306
34626666739,blackberry.net,20140510133634
94778021241,ppwap,20140510134013
32471334936,SARENS.BE,20140510134126
353864602784,wyless.net,20140510134218
6282194426999,INTERNET,20140510134420
201006078195,BLACKBERRY.NET,20140510135155
3197002170846,RITESIM.M2M,20140510135244
4541161470,INTERNET,20140510135337

2nd file

0000010514EB01497430195MTC923210006020        00923357532489          2014051101242600000000            E202AO  1                        4100361137565520021
 353278053594710 PAKUF           282632826302013020130000000000000                  M217           011933971                             966540144007
                                   00
0000020514EB01497430195MTC12642359605         00905339574666          2014051101243000000000            N215O   1                        2860150330746660021
 351553053260940 TURTC           595115951102156021560000000000000                  M217           011934131                             966540144007
                                   00

Hope I have been able to explain it clearly.

2

Could you specify the expected output? I can't see any of the pattern from file1 into file2 !

3

Do you want lines with none of the strings, or lines which are missing one or more?

e.g. given

eat,more,pie

and

I like to eat pie
I always want to eat some more pie
I'm dieting

is your expected output

I'm dieting

or

I like to eat pie
I'm dieting
4

Thanks for replying..

if you see below is an example of a record which is available

For the same I have taken the 1st column and 3rd column from the 1st file and grepped it from the 2nd file.

Similarly, the 2nd file also has the below record which does not match the pattern specified above and I want an output like the below

Let me know if you need any more information