I have sample individual addresses data which is pretty unclean. There more than 400000 observations.
MAIN MARKET OPP.POLICE STATION, ABC STREET, DELHI-400001
ABC PRINTERS, RLY NEW COLONY VISAKHAPATNAM -530016
ABC building, XYZ Road, Ville Parle (East), Mumbai 400 057
The addresses are not delimited by the same delimiter. So I have created a list of district names of India. My problem is to match each district name with all addresses. In case the string matches, i want to record the name in another variable named as 'city'. How should I match the list of city names with the string variable containing addresses?