I have an attribute that contains location information (text-based) but it will say something like “Lake View, Chicago, USA”. I want to create a column that just tells me “USA”. Note, the data isn’t regular, sometimes there are many locality details, sometimes just a country, and sometimes no country. How do I just pull out the countries?
Solved
How do I pick country names out of an attribute?

Best answer by nielsgerrits
caitlin.thorn wrote:
No unfortunately it's not. Sometimes there is other information after or there is no country, it just has a continent.
Ah I see :) one thing what comes to mind is to use a list of all possible countries and a StringSearcher to find a match. For this you have to merge all countries to all features and then search if attribute country is in attribute location.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.