How to Separate City and State from Connected Location Data in Clay Enrichment Results?

·Mar 19, 2026 08:35 PM·

Here's a total "new to Clay" question... the standard enrichment of company data always returns location as some connected string of {city, state} instead of having them separated. Is the best route to just run a formula to separate them or am I missing something more obvious?

3 comments

· Sorted by Oldest

Discuss Anything

How to Separate City and State from Connected Location Data in Clay Enrichment Results?

Anthony O.

·Mar 19, 2026 08:35 PM·

Here's a total "new to Clay" question... the standard enrichment of company data always returns location as some connected string of {city, state} instead of having them separated. Is the best route to just run a formula to separate them or am I missing something more obvious?

3 comments

· Sorted by Oldest

Igor S.
·
·
Anthony O. you don’t need to use formula. Please take a look at the screenshot attached. ‘Locations > Inferred locations’ provide very granualr split of location attributes. Hope this helps!
Anthony O.
·
·
Perfect, thanks!
1
Igor S.
·
·
Any time 🙌

Igor S.
·
·
Anthony O. you don’t need to use formula. Please take a look at the screenshot attached. ‘Locations > Inferred locations’ provide very granualr split of location attributes. Hope this helps!
Anthony O.
·
·
Perfect, thanks!
1
Igor S.
·
·
Any time 🙌