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)