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?
Yes, exactly! It's Extract Data From Values (not "Extract Values from Data"). [clay.com The correct steps are: 1. Add a new column and select Extract Data From Values
2. Reference your URL column using the Forward Slash (/) command
3. Apply this regex: [^,"]+ to split the comma-separated URLs into a proper list This will create a true list column suitable for looping enrichments.
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: [^,"]+ This regex will split the values into a proper list format and automatically trim whitespace. [clay.com [documentation 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.
You mean extract Values from Data?
Did that answer your question?
Disagree or spot an error? Submit a correction here. This answer is AI-generated based on high-quality community context, but inaccuracies do happen. Your feedback helps us maintain the best information.
Have experience with the tools discussed here? Share your honest opinion.