My requirement goes this way. I would like to add two time fields present in two different files based on join key present in both the files. And would like to move the resultant obtained as per the match keys into an other file and the one that doesn't match with the file2 into one more file. Below mentioned is an example of the same.
File1:-
TEST1 23:53:02
TEST2 22:10:02
TEST3 20:08:02
TEST4 21:09:04
TEST2 22:10:02
TEST3 20:08:02
TEST4 21:09:04
File2:-
TEST1 00:07:58
TEST2 00:08:58
TEST3 00:09:58
TEST5 00:10:58
TEST2 00:08:58
TEST3 00:09:58
TEST5 00:10:58
Where in the File1 contains the time in 24hr format and File2 just contains only mins and sec's basically the time i.e to be added. The output files should be displayed below.
Match file:-
TEST1 00:01:00
TEST2 22:19:00
TEST3 20:18:00
TEST2 22:19:00
TEST3 20:18:00
Unmatch file:-
TEST4
Can some kindly provide me the sort card in achieving the above.