EXAMPLE_DataToClean
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDE
1
YearArea (use fill down)Street (use find and replace to replace the odd character with a space)Street 2 (in Refine use titlecase and cluster and edit)Strange HTML (use unescape HTML)
2
2011BirminghamAcocksåGreenAcocks GreenOne & Two
3
2011AdderlyåStreetAdderly StreetSome – ndash
4
2011 AlcesteråRaod,åMosley Alcester Raod, Mosley€300
5
2011alcesteråroadalcester roadalcester road
6
2011alcesteråroadåmoseleyalcester road moseley"That silly man"
7
2011AlcesteråRoadåMoseleyAlcester Road Moseley<html>
8
2011AlfredåStreetAlfred StreetOne & Two
9
2011 Allåserviceåclub,åMosley All service club, MosleySome – ndash
10
2011AlumåRockåRoadAlum Rock Road€300
11
2011AlumåRockåRoadAlum Rock Roadalcester road
12
2011AlumåRockåRoadAlum Rock Road"That silly man"
13
2011AlumåRockåRoadAlum Rock Road<html>
14
2011arcadianåcentrearcadian centreOne & Two
15
2011 ArdenåRoad,åSaltley Arden Road, SaltleySome – ndash
16
2011 Asda,åChemsleyåWood Asda, Chemsley Wood€300
17
2011 BalsahllåHeathåPark,åJ/WåBrightonåroad Balsahll Heath Park, J/W Brighton roadalcester road
18
2011BamfordåRoadBamford Road"That silly man"
19
2011BamfordåRoadBamford Road<html>
20
2011BeechBrookåAvenueåSparkhillBeechBrook Avenue SparkhillOne & Two
21
2011BelchersåLaneBelchers LaneSome – ndash
22
2011BelchersåLaneBelchers Lane€300
23
2011BelchersåLaneBelchers Lanealcester road
24
2011 BelchersåLane,åBordesleyåGreen Belchers Lane, Bordesley Green"That silly man"
25
2011BellåStreetBell Street<html>
26
2011 BerkleyåRdåEastå,ååHaymills. Berkley Rd East , Haymills.One & Two
27
2011birminghamåairportbirmingham airportSome – ndash
28
2011BirminghamåInternationalårailwayåstationBirmingham International railway station€300
29
2011BordesleyåGreenBordesley Greenalcester road
30
2011 BordesleyåGreenå,ååBordesleyåGreen. Bordesley Green , Bordesley Green."That silly man"
31
2011BristolåRoadBristol Road<html>
32
2011BristolåStreetBristol StreetOne & Two
33
2011BroadåStreetBroad StreetSome – ndash
34
2011BroadåStreetBroad Street€300
35
2011BroadåStreetåBirminghamBroad Street Birminghamalcester road
36
2011BucklandåEndåLaneåShardåEndBuckland End Lane Shard End"That silly man"
37
2011 BullsåHeadåPH,åStåMarysåRow Bulls Head PH, St Marys Row<html>
38
2011 BushburyåRoad,åKittsåGreen Bushbury Road, Kitts Green
39
2011CharticeåRoadChartice Road
40
2011ChestnutåRoadChestnut Road
41
2011 churchård,åstechford church rd, stechford
42
2011 ChurchåRoad,åSheldon Church Road, Sheldon
43
2011CliffordåRDåDorridge.Clifford RD Dorridge.
44
2011ClockåLaneClock Lane
45
2011 Colonialåroad,åBordesleyåGreen` Colonial road, Bordesley Green`
46
2011 CorporationåSt,Birmingham Corporation St,Birmingham
47
2011corporationåstreetcorporation street
48
2011CoventryårdåSmallåheathCoventry rd Small heath
49
2011 COVENTRYåRD,åSMALLåHEATH,åBHAM COVENTRY RD, SMALL HEATH, BHAM
50
2011CoventryåRoadCoventry Road
51
2011CoventryåRoadCoventry Road
52
2011CoventryåRoadCoventry Road
53
2011CoventryåRoadCoventry Road
54
2011CoventryåRoadCoventry Road
55
2011 Coventryåroad,åSmallåheath Coventry road, Small heath
56
2011 CoventryåRoad,åSmallåHeath Coventry Road, Small Heath
57
2011 coventryåroad,smallåheath coventry road,small heath
58
2011CranesåParkåRoadCranes Park Road
59
2011CranesåParkåRoadåSheldonCranes Park Road Sheldon
60
2011crossfieldåroadcrossfield road
61
2011CrossfieldsåRoadåKittsåGreenCrossfields Road Kitts Green
62
2011 cxhurchård,åstechford,åbham cxhurch rd, stechford, bham
63
2011digbethåhighåstreetdigbeth high street
64
2011EdgbastonåroadEdgbaston road
65
2011EdwardåRoad.åMoseleyEdward Road. Moseley
66
2011FightingåCoxåPHFighting Cox PH
67
2011 Foremansåroad,åsparkhill Foremans road, sparkhill
68
2011 frontåoffice,åkingsåheath front office, kings heath
69
2011 GarrettsåGreenåRoad,åGarrettsåGreen Garretts Green Road, Garretts Green
70
2011GilesåCloseGiles Close
71
2011 GILESåCLOSE,åSTECHFORD GILES CLOSE, STECHFORD
72
2011glazedaleåroadglazedale road
73
2011GospelåFarmåRoadGospel Farm Road
74
2011GospelåFarmåRoadGospel Farm Road
75
2011gospelålanegospel lane
76
2011gospelålanegospel lane
77
2011GospelåLaneGospel Lane
78
2011 Gospelålane,åacocksågreen Gospel lane, acocks green
79
2011 GraceåChurch,åSuttonåColdfield Grace Church, Sutton Coldfield
80
2011GreatåHamptonåStreetGreat Hampton Street
81
2011GreenåLaneGreen Lane
82
2011GreswellålaneåShardåEndGreswell lane Shard End
83
2011 Harlequinådrive,åMosley Harlequin drive, Mosley
84
2011HaslucksåGreenåRoadHaslucks Green Road
85
2011HazeldeanåRoadHazeldean Road
86
2011HeartlandsåHospitalHeartlands Hospital
87
2011HeartlandsåHospitalHeartlands Hospital
88
2011HeartlandsåHospitalåAå&åE.Heartlands Hospital A & E.
89
2011HeartlandsåHospitalåAå&åE.Heartlands Hospital A & E.
90
2011heartlandsåhospitalåAå&åE.heartlands hospital A & E.
91
2011HepbenåGroveHepben Grove
92
2011HerrickåRoadHerrick Road
93
2011 HerrickåRoad,åWashwoodåHeath Herrick Road, Washwood Heath
94
2011 HerrickåRoad,åWashwoodåHeath Herrick Road, Washwood Heath
95
2011HighåStåSolihullHigh St Solihull
96
2011HIGHåSTREETåKINGSåHEATHHIGH STREET KINGS HEATH
97
2011HighåStreetåKingsåHeathHigh Street Kings Heath
98
2011 highåstreet,åkingsåheath high street, kings heath
99
2011HobåMooråRoadåatåStarbankåRoadHob Moor Road at Starbank Road
100
2011HollowayåheadåBhamåCityåcentreHolloway head Bham City centre
Loading...