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 column on the right
• Enter a column description
• Click Create columnThis will automatically create new columns with the specific data mapped from your enriched address information.
Source:Table columns overview | Documentation | Clay University
This 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.
Parsing Address Data: Extract City, State, and Zip Code Easily | Clay