Hi,
We are trying to extract
'PALM BEACH' from this address - "35278 A KAMLAI BHAVAN 2074 B DARSHANDARBAR RD SEC 6 PALM BEACH RD NERUL,-400478" same-wise
'NRI COMPLEX' from "2-50345 SEAWOODS ESTATES NRI COMPLEXSEC 54 56 AND 58 ROADNERUL-4007056". There are many more sample had been attached.
We had tried with text to columns but as keyword is not located at same length in each address it can't be used.'Contains' function also can't be used as keyword is not same across each address.
Is there any different approach to this problem.
Attached excel had desired output.
Please let us know anything else is needed for Analysis.
Thanks in advance
Regards,
Ramesh
Bookmarks