.png&w=3840&q=75){kind=logo}
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
Bruno R.··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 (.··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! 😊
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!