i have two files with identical no of columns. 6th columns is date (MM/DD/YY format) and 7th columns is time (HH:MM:SS) format. I need to compare these two vaules and if the date & time is higher than fileA, save it on fileC; if the value is lower, then save it on fileD
CONDITIONS
[LEFT]---------------
values from columns 2 to 5 of a raw of fileA is exactly the same as fileB
if the above condition met, then
6th & 7th columns (date & time) of each raw of fileA is higher than fileB
[/LEFT]
if both the above conditions met, put the entries of fileB which matches, on a new file fileC
if any of the above conditions are not meeting, then put those unmatching entries of fileA on new file fileD
Note :- each raw of fileA need to be compared with all the raws in fileB
fileA
-----
150 dbclstr-b IXT_Web Memphis_Prod_SQL_Full Memphis-Prod-SQL-Full-Application-Backup 04/23/11 11:24:41
129 ebs-sql1-b EBSCClaimStore Memphis_Prod_SQL_Diff Memphis-Prod-SQL-Inc-Application-Backup 04/24/11 19:58:22
6 pmemcfdb001-b ERTL Memphis_Prod_SQL_Full Memphis-Prod-SQL-Full-Application-Backup 04/23/11 11:03:18
i need to compare the 6th & 7th (date & time) column of each raw of fileA with fileB. If the values are higher, then paste the output on new file fileC and of not, paste it on fileD
You aren't helping us to understand, you 3 rows in file A and 10 rows in file b. Is it one to one comparison or you have some other criteria. Should I take the first row of A and first row of B and compare their date time and so on ?
Think from our perspective and provide the compare condition.
[LEFT]---------------
values from columns 2 to 5 of a raw of fileA is exactly the same as fileB
if the above condition met, then
6th & 7th columns (date & time) of each raw of fileA is higher than fileB
[/LEFT]
if both the above conditions met, put the entries of fileB which matches, on a new file fileC
if any of the above conditions are not meeting, then put those unmatching entries of fileA on new file fileD
Note :- each raw of fileA need to be compared with all the raws in fileB
Example :-
------------
take first line of fileA and check for any entries in fileB which matches from column 2 to 5. If matches, then go to next condition
from the matching entries, check that 6th & 7th column value of fileB is higher than fileA
if both above conditions met, save those matching entries on a new file fileD
if any of the above conditions not met, save those unmatching entries of fileA on fileD