Excel code for excel sheet data sorting
Budget: ₹1,500 – ₹12,500 INR
Greetings,
We have list of localities / area of major Indian in cities in one excel sheet.
In another excel sheet we have Pathology lab data of same Indian cities.
Complete address is given in one of the columns of Pathology lab data sheet.
We need extract locality which is prior to city name from the text string.
For example, all addresses are in below format.
Medi Clinic, Shop No. 1, Siddh Sankul, Range Hill Rd, Ashok Nagar, Pune, Maharashtra 411016, India
We need to extract text just before city name (Ashok Nagar). Need a code for the same.
We need to apply filter to the address column & search localities (from first excel sheet) from the address text string. Then respective addresses should be tagged for one or more localities depending on filter applied.
Kindly suggest & design a solution for the same.
Thanks & Regards.
We have list of localities / area of major Indian in cities in one excel sheet.
In another excel sheet we have Pathology lab data of same Indian cities.
Complete address is given in one of the columns of Pathology lab data sheet.
We need extract locality which is prior to city name from the text string.
For example, all addresses are in below format.
Medi Clinic, Shop No. 1, Siddh Sankul, Range Hill Rd, Ashok Nagar, Pune, Maharashtra 411016, India
We need to extract text just before city name (Ashok Nagar). Need a code for the same.
We need to apply filter to the address column & search localities (from first excel sheet) from the address text string. Then respective addresses should be tagged for one or more localities depending on filter applied.
Kindly suggest & design a solution for the same.
Thanks & Regards.