I have a column that contains a comma-separated list of URLs (e.g. https://a.com,https://b.com). I need to convert this into a true List column so I can run an enrichment once per URL. The Formula Generator keeps emitting JSON.stringify or JS-style output, and the result remains a string instead of a list. What is the recommended Clay-native way (Formula, Transform, or other) to reliably split a comma-separated string into a List column suitable for looping enrichments? And is there a preferred method to trim whitespace during the split?
Use Extract Data From Values to convert your comma-separated URLs into a true list:
1. Add a new column and select Extract Data From Values
2. Reference your URL column using the Forward Slash (/) command
3. Apply this custom extraction Regex: [^,"]+
Once you have the list, you can run enrichments on each URL individually. The Extract Data From Values method is the Clay-native approach specifically designed for converting comma-separated data into lists, unlike formulas which tend to return strings.
Before trying other approaches, I'd recommend using Sculptor (our built-in AI tool in the top-right corner) to help set this up quickly - it's free and can generate the exact workflow you need.
Is that what you were looking for?
You mean extract Values from Data?
Yes, exactly! It's Extract Data From Values (not "Extract Values from Data"). [1]
The correct steps are:
Add a new column and select Extract Data From Values
Reference your URL column using the Forward Slash (/) command
Apply this regex: [^,"]+ to split the comma-separated URLs into a proper list
This will create a true list column suitable for looping enrichments.
Did that answer your question?
If you still need help with converting your comma-separated URLs into a list column or using Sculptor for this, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any issues you’re encountering?
