Clay Icon

*I am looking for guidance on splitting column into multiple columns.*

·
·

I am looking for guidance on splitting column into multiple columns.

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    I am trying to split semi-colon delimited text into separate columns. Using the AI formula generator times out when I follow the CSV example. Any thoughts?

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    Sure thing. Here is my table URL.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey, thanks for reaching out! 😊 Your best approach is to use ChatGPT with JSON mode activated and mention JSON in your prompt. For example, you could say, “Extract the JSON of this /column.” Y You can also extract values from data using these steps: 1. Add the enrichment by clicking the “Add Enrichment” button in the enrichment panel (top right of the page). 2. Use a forward slash (”/”) to add the column in the data. 3. Select Custom. 4. Add this Regex: [^\s,]+ 5. Run it. This will give you unique columns. If you encounter quotation marks in the JSON, go into the settings of those columns and use aformula to remove them. Let me know if you need any more guidance! 👍

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    I'm trying to avoid hitting OpenAI or using a Clay credit to split the text apart.

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    I'm trying to split semi-colon delimited text. Using that regex, it's not splitting properly. I'm trying to use ChatGPT to generate the correct regex, but I'm pretty rusty on them. Any ideas?

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    Hey Bill, I noticed a few changes and took some time to check and update the prompt with Claygent. I’d also suggest removing some selection options, but you can still force Claygent to return specific outputs (ideally 3-4) for better accuracy. I added all of them in there for now. Adding too many values can cause confusion and lead to more hallucinations, which is something to avoid. The way I set it up ensures all values will be returned as individual rows for easy processing. More details on what I used: Claygent Let me know if you need any further adjustments! 😊

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    Hi Bo (., this was very helpful. Is there any documentation on how to configure Claygent with the fields like you did? The video you linked appears to show an earlier version of Claygent.

  • Avatar of Bo (.
    Bo (.
    ·
    ·

    There's Claygent Neon which might help understanding more. It is our own AI model, but for Claygent and your API Key, it’s essentially just about adding clear output. 😊 Think of it as an add-on to enhance your prompt! Let me know if you need more details! 🙂

  • Avatar of Bill L.
    Bill L.
    ·
    ·

    This is very helpful. I understand the proper use of Claygent much better now. I appreciate the 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 Bill L.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: