How to Split Multiple Domains into Separate Columns in Excel | Clay

How to Split Multiple Domains into Separate Columns in Excel

I have column that lists multiple domains like: google.com;apple.com;abc.com I want to split the domains into separate columns. How can I do this?

5 comments

Clay
APP
·
·
You can split domains into separate columns using our AI Formula Generator: 1. Click Add Column → Formula 2. Use the AI Formula Generator and enter instructions like "Split {{Your Column Name}} by comma into separate values" 3. Click Generate formula to create the splitting formula Alternatively, if your domains are comma-separated, you can use the Extract Data From Values feature: 1. Apply a custom extraction regex: [^,"]+"?[^,"]+ 2. This will split the values into a list that you can then map to separate columns The AI Formula Generator can handle various splitting scenarios - just describe how you want to split your domain data and it will create the appropriate formula.
Sources: Formula generator | Documentation | Clay University Formula generator | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Nicole B.
·
·
How do I use extract data from values feature? Also, it is semi-colon separated
Clay
APP
·
·
For semi-colon separated domains, use Extract Data From Values: 1. Use Extract Data From Values to process your data 2. Add the correct column using the Forward Slash (/) command 3. Apply a custom extraction Regex: [^;"]+"?[^;"]+ (modified for semi-colons) This will split the values into a list that you can then send to separate columns using write to table.
Sources: Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University Write to Other Table | Documentation | Clay University
Nicole B.
·
·
Where do I find "Extract Data From Values?"
Clay
APP
·
·
The feature is called "Extract Values from Data" and you can find it when adding a new column. Click Add Column and look for the "Extract Values from Data" integration. This integration lets you extract specific values from various data types using patterns like regex to identify and retrieve targeted information from your data.
Source: Extract Values from Data with Clay