Clay Icon

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

  • Avatar of Bruno R.
    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!

  • Avatar of Alberto
    Alberto
    ·
    ·

    Text Is already in clay, is a result of Owler enrichment

  • Avatar of Bo (.
    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! 😊

  • Avatar of Channeled
    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!

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Hi Alberto! This thread was recently closed by our Support team. If you have a moment, please share your feedback: