How to Extract Country from Location Column in a Table

Daniel C.

·

Hi, this is probably a dumb question but how do I pull just the "Country" from the location column of a table?

✅1

10 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Daniel C.
·
·
https://app.clay.com/workspaces/43481/tables/t_J9G3ntIhPaYw/views/gv_9f3UqERltS6k
Clay Team
APP
·
·
Hey Daniel, thanks for reaching out! taking a look at your setup
Clay Team
APP
·
·
Using conditional formulas could work for this but it, unfortunately, can't infer if it's in fact a country or not, it will only return the available results that are stored in that cell. For example, some may only mention the city or state and that's what it will return, if the country is present then it will return it.
Clay Team
APP
·
·
Perhaps using chatGPT may be the best way to infer and achieve this more accurately. Hope this helps!
Daniel C.
·
·
Yeah, I think I've used conditional formulas in the past for this but I just don't remember how to go about it.
Clay Team
APP
·
·
Yep, as mentioned, the formula generator doesn't have context or can't infer every country on its own so if you try to do that you'll have to specify what it returns based on the input which could be tedious.For example, some rows only have "San Francisco" or another city but doesn't mention the country. When you prompt the formula generator you'll have to specify that if it says "San Francisco" then return "United States" or "US", and will have to do this for every city that is formatted this way.Hence, chatGPT will be easier to get around that issue since it already has the context, all you need is to prompt it and provide the input.
Daniel C.
·
·
Ah, ok - well - thank you for helping
Daniel C.
·
·
and clarifying there.
Daniel C.
·
·
I'll try Chat GPT

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Daniel C.
·
·
https://app.clay.com/workspaces/43481/tables/t_J9G3ntIhPaYw/views/gv_9f3UqERltS6k
Clay Team
APP
·
·
Hey Daniel, thanks for reaching out! taking a look at your setup
Clay Team
APP
·
·
Using conditional formulas could work for this but it, unfortunately, can't infer if it's in fact a country or not, it will only return the available results that are stored in that cell. For example, some may only mention the city or state and that's what it will return, if the country is present then it will return it.
Clay Team
APP
·
·
Perhaps using chatGPT may be the best way to infer and achieve this more accurately. Hope this helps!
Daniel C.
·
·
Yeah, I think I've used conditional formulas in the past for this but I just don't remember how to go about it.
Clay Team
APP
·
·
Yep, as mentioned, the formula generator doesn't have context or can't infer every country on its own so if you try to do that you'll have to specify what it returns based on the input which could be tedious.For example, some rows only have "San Francisco" or another city but doesn't mention the country. When you prompt the formula generator you'll have to specify that if it says "San Francisco" then return "United States" or "US", and will have to do this for every city that is formatted this way.Hence, chatGPT will be easier to get around that issue since it already has the context, all you need is to prompt it and provide the input.
Daniel C.
·
·
Ah, ok - well - thank you for helping
Daniel C.
·
·
and clarifying there.
Daniel C.
·
·
I'll try Chat GPT