Splitting Address Data into Multiple Columns Using Regex in SFDC

Justin T. · 2025-02-27T21:47:27.604013+00:00

How do I split the enriched Address - Locations 4655 Great America Parkway, Suite 300, Santa Clara, CA 95054, US into multiple columns? Trying to enrich SFDC Account.Address but need this to be regex'ed into multiple columns. Id liek to not use Claygent credits if possible. Is there a JSON function or some advanced regex I could use?

You can split the enriched "Address - Locations" field into multiple columns without using Claygent credits by using Clay's native data cleaning tools and column creation features. Here's how: 1. Create child columns from the parent "Address - Locations" column: • Click on a cell in the enriched column • In the Cell details panel, hover over the desired endpoint and click "Add as column" • Enter a description for the new column and click "Create column" 2. Use Clay's native data cleaning tools to normalize the location data: • These tools are credit-free and can help standardize address formats 3. For more advanced manipulation, you can reference specific endpoints within the enrichment using Clay's dynamic data referencing: • Select the desired fields (e.g., street, city, state, zip) from the enrichment data This approach allows you to split and organize your address data without using additional Claygent credits.

Sources: Referencing dynamic data from other columns | Documentation | Clay University Data Cleaning + Normalization [Automated Inbound] - Clay University Table columns overview | Documentation | Clay University

2 comments