Extracting different elements of global addresses

[Jack Ronson]

Hi all,

I have a long list of addresses from around the world, written in various formats by different participants. Some are just countries, some cities and countries, some just zip codes, some all of the above etc

Is there any uniform way to extract each piece of information individually from each address so that for each observation I have a value for country, city, zipcode?

[Andrew Musau]

Welcome to Statalist. Your question is too vague and the unhelpful answer is that it all depends on the organization of the dataset. Extracting countries may be less complicated than cities or zip codes as you can match entries to a dictionary that includes all the countries in the world. So a data example would be most helpful here. See FAQ Advice #12 on how to present one using the dataex command. Something similar, for context, is at https://www.statalist.org/forums/for...y-address-data.