I am currently parsing the dataset we have, Need to validate cleansed dataset for error.
I have the complete address in 1st column and have parsed the data in adjacent columns, Now I need to validate that the information is parsed correctly.
For example, the postcode in Cell G1 is part of the address in cell A1.
Thank you for your time in reviewing my question.
I have the complete address in 1st column and have parsed the data in adjacent columns, Now I need to validate that the information is parsed correctly.
For example, the postcode in Cell G1 is part of the address in cell A1.
Book1 | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | |||
1 | Address | Address 1 | Address 2 | Address 3 | City | State | Post Code | Country | ||
2 | Tour B, Cœur Défense, 110 Espl. du Général de Gaulle, 92400 Courbevoie | Tour B | Cœur Défense | 110 Espl. du Général de Gaulle | Courbevoie | 92400 | France | |||
3 | Unit 1, Chancellor Court, 50 Occam Rd, Guildford GU2 7AB, United Kingdom | Unit 1 | Chancellor Court | 50 Occam Road | Guildford | Surrey | GU2 7AB | United kingdom | ||
4 | Gorey Rd, Money Little, Arklow, Co. Wicklow, Y14 E284, Ireland | Gorey Road | Money Little | Arklow | Co. Wicklow | Y14 E284 | Ireland | |||
5 | Digital Office Centre Swords, Suite 101-103, Balheary Rd, Balheary Demesne, Swords, Co. Dublin, Ireland | Suite 101-103 | Digital Office Centre Swords | Balheary Rd Balheary Demesne Swords | Co. Dublin | K67E5AO | Ireland | |||
6 | Unit 1 - 3 and Unit 6 - 8, EuroWay Industrial Estate, Blagrove, Swindon SN5 8YW, United Kingdom | Unit 1 - 3 and Unit 6 - 8 | EuroWay Industrial Estate | Blagrove | Swindon | Wiltshire | SN5 8YW | United kingdom | ||
7 | Abbeytown Rd, Knocknashee, Boyle, Co. Roscommon, F52 K167, Ireland | Abbeytown Road | Knocknashee | Boyle | Co. Roscommon | F52 K167 | Ireland | |||
8 | Mulliner House, Flanders Rd, Chiswick, London W4 1NN, United Kingdom | Mulliner House | Flanders Road | Chiswick | London | W4 1NN | United kingdom | |||
9 | Sovereign House, Vision Park, Chivers Way, Histon, Cambridge CB24 9BZ, United Kingdom | Sovereign House | Vision Park | Chivers Way Histon | Cambridge | Cambridgeshire | CB24 9BZ | United kingdom | ||
10 | Units 1-4 IDA Industrial Estate, Cork Rd, Waterford, Ireland | Units 1-4 | IDA Industrial Estate | Cork Road | Waterford | X91 RP79 | Ireland | |||
11 | Waterford Industrial Park, Unit 301, Cork Rd, Waterford, X91 WK68, Ireland | Unit 301 | Waterford Industrial Park | Cork Road | Waterford | X91 WK68 | Ireland | |||
12 | BLACKWOOD HALL BUSINESS PARK, Woodland House, Cornelius Causeway, Selby YO8 5DD, United Kingdom | BLACKWOOD HALL BUSINESS PARK | Woodland House | Cornelius Causeway | Selby | North Yorkshire | YO8 5DD | United kingdom | ||
13 | Croom Enterprise Centre, Kilmallock Road, Croom, Co. Limerick, Ireland | Croom Enterprise Centre | Kilmallock Road | Croom | Co. Limerick | A81 YK06 | Ireland | |||
14 | Unit 5, Zephyr Building, Eighth St, Harwell Campus, Harwell, Didcot OX11 0RL, United Kingdom | Unit 5 | Zephyr Building | Eighth St Harwell Campus | Didcot | Oxfordshire | OX11 0RL | United Kingdom | ||
15 | Campus do Lumiar, Edifício R, Estrada do Paço do Lumiar, 1649-038 Lisboa, Portugal | Campus do Lumiar | Edifício R | Estrada do Paço do Lumiar | Lisboa | 1649-038 | Portugal | |||
16 | Medina House, Globe Business Park, Fieldhouse Ln, Marlow SL7 1TB, United Kingdom | Medina House | Globe Business Park | Fieldhouse Lane | Marlow | Buckinghamshire | SL7 1TB | United kingdom | ||
17 | Unit 6, IDA, Galway Business Park, Galway, H91 W7CP, Ireland | Unit 6 | IDA | Galway Business Park | Galway | H91 W7CP | Ireland | |||
18 | Unit 1, Vanguard Industrial Estate, Henwood, Ashford TN24 8DH, United Kingdom | Unit 1 | Vanguard Industrial Estate | Henwood | Ashford | Kent | TN24 8DH | United kingdom | ||
Sheet1 |
Thank you for your time in reviewing my question.