Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

03 Tutorials & Inspiration

03 Tutorials & Inspiration

Transforming Comma-Separated Text into a Readable List for Clay Lab

·

·

Good morning - Is there a way to transform a text into a list that can be read by Clay Lab and transfered into another table. In the text i have a comma separated list. Thank you

Transforming Comma-Separated Text into a Readable List for Clay Lab | Clay

5 comments

· Sorted by Oldest

Bruno (Clay)
·
·
Hi Alberto, thank you for reaching out. Could you please let me know where this text is currently stored? The first step is to convert the text into a format that can be imported into Clay. If you can map your text to an Excel or Google Sheets file, you can then export it as a CSV, which Clay can read and process. The next step is to use AI formulas to transform these lists into the desired table structures. Here's a video that explains how to use AI formulas for these transformations: https://www.loom.com/share/8e3eee088c0e4608ade3cffb69b0011d?sid=601de08d-8597-4d3e-b08c-37f64a03865d I hope this was helpful. If there's anything else I can assist you with, please let me know!
Alberto
·
·
Text Is already in clay, is a result of Owler enrichment
Bo (Clay)
·
·
Hey, thanks for reaching out! 😊 Here’s how you can extract values from your data and pass them to another table: 1. Add the “Extract Values from Data” enrichment. 2. Use Custom Extraction Type. 3. Apply Regex: • For text: use this regex: [^\s,"]+ • For domains: use this regex: https://[^\s,"]+ 4. This will extract values as a list. Here’s a tutorial on how to pass data into another table without using a list: Loom Video. Feel free to send the table if you need more help! 😊
Channeled
APP
·
·
We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!
Channeled
APP
·
·
Hi Alberto! This thread was recently closed by our Support team. If you have a moment, please share your feedback: