How to Split an Address into Separate Columns in Excel | Clay

How to Split an Address into Separate Columns in Excel

I need to take an address and split it so I can write each part to it's own column. Example: 1220 E Campbell Rd,Richardson,TX,75081.

5 comments

Clay
APP
·
·
To split an address into separate columns: 1. Use "Extract Data From Values" to process your comma-separated address 2. Add the appropriate columns using the "/" command 3. Apply the custom extraction regex: [^,"]+"?[^,"]+ This will split your address (like "1220 E Campbell Rd,Richardson,TX,75081") into separate values that you can then send to individual columns using our write to table feature.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Table columns | Documentation | Clay University
Joel M.
·
·
what regex pattern do I use for an address?
Clay
APP
·
·
For splitting an address like "1220 E Campbell Rd,Richardson,TX,75081" into separate columns, use the regex pattern: [^,"]+"?[^,"]+ To implement this: 1. Use "Extract Data From Values" to process your comma-separated address 2. Add the appropriate columns using the "/" command 3. Apply this custom extraction regex This will split each part of your address into separate values that you can then send to individual columns using our write to table feature.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Joel M.
·
·
is "extract values from data" the same thing?
Clay
APP
·
·
Yes, "Extract Values from Data" is the correct name of the Clay feature you need for splitting an address. This integration lets you define patterns to extract specific information from text, which is perfect for separating address components. You can then use our write to table feature to send each component to its own column.
Source: Extract Values from Data with Clay