.png){kind=logo}
Parsing Address Data: Extract City, State, and Zip Code Easily
I have enriched data for companies/contacts that includes address. Is there an easy way to parse out the zip code, state, and city into a new column?
You can easily create separate columns for zip code, state, and city from your enriched data by following these steps: 1. Click on any cell containing the enriched address data. This will open the Cell details panel on the right. 2. In the panel, you'll see different endpoints (like city, state, zip code). For each piece of information you want to extract: • Hover over the specific endpoint • Click
Add as columnon the right • Enter a column description • ClickCreate columnThis will automatically create new columns with the specific data mapped from your enriched address information. Source: Table columns overview | Documentation | Clay UniversityThis thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.