Spreadsheet: 41607d1240147740-comparing-and-deleting-data-in-2-columns-test-data
Sheet: Original DB

UniqueId | ReferenceNo | cardnumber | carddesc | pincode | doorgroup | cardstatus | pinretries | cardid | times | comment | spare | downloadfl | designation | department | phone | unpacked | Spare1 | Spare2 | Spare3 | Spare4 | Spare5 | Spare6 | Spare7 | Spare8 | Spare9 | Spare10 | Spare11 | AccessLevel | VisitorsLevel | InOut | LastDoor | SwipeDate | IsoSwipeDate | SwipeTime
28110 | 5 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 1 | 0 | OUT | 6 OPT Entrance [121] | 2005-05-19 00:00:00 | 2004-09-23 | 11:57:12
28111 | 6 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 8 | 0 | OUT | 2 Staff DischargeLounge | 2005-05-16 00:00:00 | 2005-05-16 | 15:09:48
28112 | 4 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 14 | 0 | OUT | 2 MAT Main Ent [107] | 2005-04-11 00:00:00 | 2004-09-23 | 23:47:21
28113 | 7 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 7 | 0 | OUT | 28 OPD StreetEntry [81] | 2005-05-22 00:00:00 | 2004-09-14 | 14:38:32
28114 | 2 | 4167 | A Belatreche |  | 0 | 0 | 3 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 2 | 0 | OUT | 13 EAST C/P ENTRY | 2005-05-12 00:00:00 | 2004-09-20 | 15:47:10
28115 | 3 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 25 | 0 | OUT |  | 00:00:00 | 1899-12-30
28116 | 12 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 6 | 0 | OUT |  | 00:00:00 | 1899-12-30
32591 | 8 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 3 | 0 | OUT | 24 NUC StreetEntry [117 | 2005-05-03 00:00:00 | 1899-12-30 | 14:58:54
32592 | 9 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | PASS | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 5 | 0 | OUT | 1 NUM StreetEntry [134] | 2005-02-12 00:00:00 | 1899-12-30 | 01:09:22
130583 | 10 | 4167 | A Belatreche |  | 0 | 0 | 0 | 4167 |  | Lost - replaced with 4636 |  | SUSP | Senior SHO | Oral Maxfax |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 0 | 0 | OUT |  | 00:00:00 | 1899-12-30
104975 | 3 | 6876 | A Clowes |  | 0 | 0 | 0 | 6876 |  | No Comments |  | PASS | Treetops |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | 0 | OUT | 32 Ind St XOver Rr[32] | 2009-02-07 00:00:00 | 2009-02-07 | 18:44:25
104977 | 2 | 6876 | A Clowes |  | 0 | 0 | 3 | 6876 |  | No Comments |  | PASS | Treetops |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | 0 | OUT | Barrier out hosp rear | 2009-04-03 00:00:00 | 2009-03-26 | 16:52:58
176778 | 4 | 6876 | A Clowes |  | 0 | 0 | 0 | 6876 |  | No Comments |  | PASS | Treetops |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | 0 | OUT |  | 00:00:00 | 1899-12-30
11017 | 3 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 25 | 0 | OUT | 32 Ind St XOver Rr[32] | 2009-01-13 00:00:00 | 2008-05-13 | 07:37:04
12432 | 2 | 10809 | A Eeles |  | 0 | 0 | 3 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 2 | 0 | OUT | 9 S4 C/P EXIT | 2009-04-08 00:00:00 | 2008-05-13 | 16:37:14
21645 | 7 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 3 | 0 | OUT | 10 AED Childrens [253) | 2009-04-08 00:00:00 | 2008-05-13 | 16:28:58
24315 | 4 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 14 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
54465 | 12 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 8 | 0 | OUT | 16 OPD [NAME] | 2009-04-06 00:00:00 | 1999-12-30 | 15:24:51
117473 | 10 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | SUSP | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 0 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
164241 | 5 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 10 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
164242 | 6 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 8 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
164243 | 8 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 13 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
164244 | 9 | 10809 | A Eeles |  | 0 | 0 | 0 | 1472 |  | No Comments |  | PASS | Emergency Nurse Prac. | Emergency Dept. | 2302 |  |  |  |  |  |  |  | Trust | M933 SVO   M633 SVO |  |  |  | 5 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
14975 | 2 | 3290 | A K Narayansamy |  | 0 | 0 | 3 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 2 | 0 | OUT | 5 Trust HQ [31] | 2006-02-02 00:00:00 | 2004-12-03 | 15:09:49
14976 | 3 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 25 | 0 | OUT |  | 00:00:00 | 1899-12-30
18708 | 5 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 1 | 0 | OUT | 4 OPT Entrance [126] | 2006-02-03 00:00:00 | 2005-02-10 | 08:39:39
18709 | 6 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 1 | 0 | OUT | 12 CHU Entrance [158] | 2006-01-25 00:00:00 | 2005-01-14 | 08:30:47
18710 | 4 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 14 | 0 | OUT | 31 V2 C/P Entry [???] | 2005-11-14 00:00:00 | 1899-12-30 | 19:04:09
41466 | 8 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 3 | 0 | OUT | 13 NUE/NUC Divide [115] | 2006-02-02 00:00:00 | 1899-12-30 | 22:20:35
41467 | 9 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 6 | 0 | OUT | 1 NUM StreetEntry [134] | 2005-11-22 00:00:00 | 1899-12-30 | [NAME]
41468 | 7 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 6 | 0 | OUT | 23 EastStairFireDr[503] | 2006-02-01 00:00:00 | 1899-12-30 | 19:43:39
41469 | 12 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | PASS | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 6 | 0 | OUT | 11 1st Fl WestLiftLobby | 2005-02-14 00:00:00 | 1899-12-30 | 22:01:18
124443 | 10 | 3290 | A K Narayansamy |  | 0 | 0 | 0 | 3290 |  | No Comments |  | SUSP | SHO | Anaes |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 0 | 0 | OUT |  | 00:00:00 | 1899-12-30
139764 | 7 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 7 | 0 | OUT |  | 00:00:00 | 1899-12-30
139765 | 9 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 5 | 0 | OUT | 2 MHD StreetEntry [135] | 2007-02-08 00:00:00 | 1899-12-30 | 15:41:07
139766 | 8 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 13 | 0 | OUT |  | 00:00:00 | 1899-12-30
139768 | 10 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 6 | 0 | OUT |  | 00:00:00 | 1899-12-30
139769 | 4 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 14 | 0 | OUT |  | 00:00:00 | 1899-12-30
139770 | 6 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 8 | 0 | OUT | 4 NUG Entrance [150] | 2007-02-08 00:00:00 | 1899-12-30 | 15:50:20
139771 | 5 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 1 | 0 | OUT | 6 OPT Entrance [121] | 2007-02-12 00:00:00 | 1899-12-30 | 10:32:13
139772 | 3 | 8991 | [NAME] |  | 0 | 0 | 0 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 25 | 0 | OUT |  | 00:00:00 | 1899-12-30
139774 | 2 | 8991 | [NAME] |  | 0 | 0 | 3 | 8991 |  | No Comments |  | PASS | SHO | T&O |  |  |  |  |  |  |  |  | Trust |  |  |  |  | 2 | 0 | OUT |  | 00:00:00 | 1899-12-30
5094 | 3 | 2824 | a.grove  2824 |  | 0 | 0 | 0 | 2824 |  | No Comments |  | PASS | gardener | Interserve |  |  |  |  |  |  |  |  |  | vx52emr |  |  |  | 2 | 0 | OUT | 3 [NAME] exit (side)[19] | 2009-04-07 00:00:00 | 1999-12-30 | 13:02:13
11166 | 2 | 2824 | a.grove  2824 |  | 0 | 0 | 3 | 2824 |  | No Comments |  | PASS | gardener | Interserve |  |  |  |  |  |  |  |  |  | vx52emr |  |  |  | 2 | 0 | OUT | Barrier out hosp rear | 2009-04-08 00:00:00 | 1999-12-30 | 15:40:52
22441 | 4 | 2824 | a.grove  2824 |  | 0 | 0 | 0 | 2824 |  | No Comments |  | PASS | gardener | Interserve |  |  |  |  |  |  |  |  |  | vx52emr |  |  |  | 15 | 0 | OUT | 34 MAT C/P Exit [???] | 2009-03-06 00:00:00 | 1999-12-30 | 05:59:33
101695 | 12 | 2824 | a.grove  2824 |  | 0 | 0 | 0 | 2824 |  | No Comments |  | PASS | gardener | Interserve |  |  |  |  |  |  |  |  |  | vx52emr |  |  |  | 8 | 0 | OUT | 17 Back Road Ramp IN | 2009-04-08 00:00:00 | 1999-12-30 | 15:39:57
121104 | 10 | 2824 | a.grove  2824 |  | 0 | 0 | 0 | 2824 |  | No Comments |  | SUSP | gardener | Interserve |  |  |  |  |  |  |  |  |  | vx52emr |  |  |  | 0 | 0 | OUT |  | 1999-12-30 00:00:00 | 1999-12-30
3596 | 2 | 596 | a.hughes  596 |  | 0 | 4 | 3 | 596 |  | No Comments |  | PASS | porter | Interseve |  |  |  |  |  |  |  |  |  | e493soa |  |  |  | 1 | 0 | IN | Barrier out hosp rear | 2009-04-06 00:00:00 | 2007-03-29 | 12:55:22
5091 | 3 | 596 | a.hughes  596 |  | 0 | 0 | 0 | 596 |  | No Comments |  | PASS | porter | Interseve |  |  |  |  |  |  |  |  |  | e493soa |  |  |  | 11 | 0 | OUT | 4 FM Main Entrance [17] | 2009-04-04 00:00:00 | 2006-05-15 | 12:21:21