Hello all,
Can anyone help me with this.
There are two files and I have to match the second file records with that of first and if matched, print the output in two fies, one containing the matched records and other containing the rest.
Here is the example.
Code:
File1
"111",erter,"00000", ,"567"
"gh6",erter,"00000", ,"567"
"1t7",erter,"00000", ,"yu7"
"yu8",erter,"00000", ,"5h7"
--
--
--
Code:
file2
111
345
yu8
--
--
As can be seen 111 and yu8 matches with the first reord in file 1, so the whole row should be printed.
Output should be
Code:
file3
"111",erter,"00000", ,"567"
"yu8",erter,"00000", ,"5h7"
--
--
and
file4
"gh6",erter,"00000", ,"567"
"1t7",erter,"00000", ,"yu7"
---
---
-
Can anyone help me with this. Thanks.
