Hello,
I need to combine File1 and File2 to result in File3...
File1:
SR Tendulkar,1989-2011,453,18111,200*,48,95,20
RT Ponting,1995-2011,370,13686,164,30,82,20
ST Jayasuriya,1989-2011,445,13430,189,28,68,34
Inzamam-ul-Haq,1991-2007,378,11739,137*,10,83,20
JH Kallis,1996-2011,317,11372,139,17,84,16
File2:
SR Tendulkar,1989-2011,184,15183,248*,51,63,14
R Dravid,1996-2011,160,13094,270,36,62,8
RT Ponting,1995-2011,158*,12640,257,39,58,16
JH Kallis,1995-2011,147,12005,201*,40,55,11
BC Lara,1990-2006,131,11953,400*,34,48,17
File3:
SR Tendulkar,1989-2011,637,33294,248*,99,158,34
RT Ponting,1995-2011,528*,26326,257,69,140,36
JH Kallis,1995-2011,464,23377,201*,57,139,27
ST Jayasuriya,1989-2011,445,13430,189,28,68,34
R Dravid,1996-2011,160,13094,270,36,62,8
BC Lara,1990-2006,131,11953,400*,34,48,17
Inzamam-ul-Haq,1991-2007,378,11739,137*,10,83,20
Rule for combination...
If player (field 1) is in both files, combine as following...
Field 2: Use the larger range (ex. 1995-2010 over 1997-2009)
Field 3: Add the 2 numbers. If * exists with either number, Keep *
Field 5: Use larger number. Keep * only if exists with larger #
Field 4,6,7,8: Add the 2 numbers
If player (field 1) is not in both files, simply duplicate row in File3.
Hope the above is clear. Thanks in advance for the help.
Arun
I need to combine File1 and File2 to result in File3...
File1:
SR Tendulkar,1989-2011,453,18111,200*,48,95,20
RT Ponting,1995-2011,370,13686,164,30,82,20
ST Jayasuriya,1989-2011,445,13430,189,28,68,34
Inzamam-ul-Haq,1991-2007,378,11739,137*,10,83,20
JH Kallis,1996-2011,317,11372,139,17,84,16
File2:
SR Tendulkar,1989-2011,184,15183,248*,51,63,14
R Dravid,1996-2011,160,13094,270,36,62,8
RT Ponting,1995-2011,158*,12640,257,39,58,16
JH Kallis,1995-2011,147,12005,201*,40,55,11
BC Lara,1990-2006,131,11953,400*,34,48,17
File3:
SR Tendulkar,1989-2011,637,33294,248*,99,158,34
RT Ponting,1995-2011,528*,26326,257,69,140,36
JH Kallis,1995-2011,464,23377,201*,57,139,27
ST Jayasuriya,1989-2011,445,13430,189,28,68,34
R Dravid,1996-2011,160,13094,270,36,62,8
BC Lara,1990-2006,131,11953,400*,34,48,17
Inzamam-ul-Haq,1991-2007,378,11739,137*,10,83,20
Rule for combination...
If player (field 1) is in both files, combine as following...
Field 2: Use the larger range (ex. 1995-2010 over 1997-2009)
Field 3: Add the 2 numbers. If * exists with either number, Keep *
Field 5: Use larger number. Keep * only if exists with larger #
Field 4,6,7,8: Add the 2 numbers
If player (field 1) is not in both files, simply duplicate row in File3.
Hope the above is clear. Thanks in advance for the help.
Arun