Hi Experts,
Facing Same problem…Would you please help me on the below scenario POSTED…INDIA ADDRESS CLEANSE
Below is the Source data, which has complete address in one single column, however Client wants
this address column into 3 columns as Add_line1, Add_line2, Add_line3, City, Region, Pincode
Would somebody please help me…on this
This Address has different formats: For exampleÂ…
- Few address has ‘,’ COMMA separated
- Few with SPACE separated
- Few with NOTHING
Nos
Source
1
55444, 212th Main, ITI L/O Mallathahalli Bnaglore-42145
2
18446 B,Ranka Colony,Bilekahalli,Bannarghatta Road,Hyderabad-143121
3
#301, 65th main, 125th Cross, Cross extension, Vivek Nagar,Hyderabad-874545
4
Plot # 542,BHS Layout,101th A Cross,184th Main,SanthnagarBommanahalli,Bangalore-1245454
5
#0542427, GF, 24540th Main,455th Cross, Sector 1, HSR Lay Out,Hyderabad-624515
6
King Apartment, Sumana Nagar, Near 5454 Main Hospital, Vijay Nagar, Marol-Mahroshi Road, Andheri East, Hyderabad 400059.
7
Residency Jet Mumbai,Opp. Techniplex Compamy Off S.V.Road, Goregaon (W), Pune
8
Pop & Ben Corporate Stay,B706, 107th Floor, Joy Valencia.Near Majas Bus Depot Jogeshwari East Thane
9
Sao Ashok Nagar, Borla, Govandi Hyderabad 400088
10
Plot No.54534/6Yet Home Colony Opp.Of Maharaja LightKarvenagar
11
Room No.2orgage ColonySr.No.487/8DAzadwadiKothrudHyderabad545745
12
Sr.No.14352/149454Building No-202Ajmera ColonyPimpriHyderabad-411018
aamarnath (BOB member since 2015-06-03)